# 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.

• ✭✭

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

• edited 11/30/20

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.

• ✭✭

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)

## Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!