Need help with a Date formula

Topic Labels: Formulas
705 4
Showing results for 
Search instead for 
Did you mean: 
4 - Data Explorer
4 - Data Explorer

I’m trying to forecast revenue for my company. I have a table, and basically what I want it to do is tell me:

If Order Date Created is “X”, and payment method is “Y”, add “Z days” to Order Date and output new date.

Can’t quite figure it out. For example, if they paid with a credit card, I know their payment will settle today. But if they paid by check, I can forecast the revenue out 2 weeks or so.

Anyone know how to do this?

4 Replies 4
11 - Venus
11 - Venus

The formula would look like this

DATEADD({order date}, {dateadd (from payment method)}&'', 'day')

For some reason, it does not work correctly without &''

The second parameter should be a number, but you are forcing the value into a string. Is your middle field a lookup field?

Yes, it is a Lookup.
If it is a Number field in a table, there is no need for an empty string.

I can (and have) created a value for "Payment Clearing Time. So it is a number now. So basically I need “Created Date” + “Number of days” = “New Date”