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?
Solved! Go to 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.
When I run those formulas, my values come back as null.
Actually, just my payment expected format is coming back with null. It says the format is not a valid Date.
Hi @BrandonS4 can you provide an sample excel file with just that row of data.
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!