I need guidance on making a formula that takes a date and compares it to today and then adds a number of days to it based on difference.
If <30 add 15 If >30<45add30...
The box would not let me finish the question. Basically, I need to take a date "3/22/21" from today which is 117 days out. If that number is greater than 60, I need to add 60 days to 3/22/21 if it were only 33 days out, I need to add 30days
I believe this is what you need. I suppose you have a column named InitialDate with the date 03/22/21, for example.
1) Create a column with type "CalculatedDate"
2) formula --> = [email protected] + IF([email protected] - TODAY() > 60, 60, 30)
= [email protected] + IF([email protected] - TODAY() > 60, 60, 30)
With the formula, you will add 60 days in case the difference between InitialDate and Today is greater than 60, or else you will add just 30 days.
I hope that was helpful.
Thank you! I will try. I have 4 options. 0-29 add 15, 30-44 add 30, 45-59 add 45 and add 60. How will that look at the end of that formula?
This is what I entered based on my column names and I got an #invalid operation.
=[Const Completion]@row + IF([Scheduled - Days Out]@row - TODAY() > 60, 60)