Formula to Calculate Expected Payment of Invoice

I have the below columns in an Excel document. I am curious what formula I can put in column E to calculate when payment will be expected based on average days to pay. In this example, this customer pays 15 days late so I know payment is expected 05/15/20 but what formula will show me that?

Date Time

Accepted answers

JosephSerpis

Hi @BrandonS4 I mocked up a workflow let me know what you think. It produces the date in alteryx format which is YYYY-MM-DD and also in your original format as well.

Dates_23042020.yxmd

All comments

JosephSerpis

Hi @BrandonS4 I mocked up a workflow let me know what you think. It produces the date in alteryx format which is YYYY-MM-DD and also in your original format as well.

Dates_23042020.yxmd

BrandonS4

When I run those formulas, my values come back as null.

Quick Links

Unanswered
Community Events
Groups

This months top contributors

atcodedog05 19598

Qiu 15880

binu_acs 15708

MarqueeCrew 13708

apathetichell 13703