You will need to replace order date with your date field
Thank you for your help,
Where should I put this formula in? as a new calculation in the columns/rows?
I have replicated the formula, but it is in Red and says it is invalid...I think I am doing something wrong...please help :-)
1 of 1 people found this helpful
Now it works! thank you!
The formula should be a calculated field.
What is the error the formula displays?
Also did you remember to change [order date] to your required date throughout the formula