If formula using dates and adding to date
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...
Answers

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 >
= InitialDate@row + IF(InitialDate@row  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. 029 add 15, 3044 add 30, 4559 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)
Help Article Resources
Categories
Check out the Formula Handbook template!