Formula to Calculate Expected Payment of Invoice

[BrandonS4]

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?

[JosephSerpis · Accepted solution]

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.

[BrandonS4]

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

[BrandonS4]

Actually, just my payment expected format is coming back with null.  It says the format is not a valid Date.

[JosephSerpis]

Hi @BrandonS4 can you provide an sample excel file with just that row of data.

[BrandonS4]

I got it to work.  I just had to change the way the date was being formatted and now it is showing correct.  Thank you so much for your help and your quick reply!