Adding Month and Days to a Cell

Options
Lisi
Lisi
edited 12/09/19 in Formulas and Functions

Hello everyone,

I have a Completion Date of 1/08/2019 and I need the next cell to be 1/29/2019 (which is ten days before 2/8/2019) and the third cell to be 2/18/2019 (which is ten days after 2/8/2019). I've tried every which way I could think of to get this to work. Any ideas?

THANK YOU!

 

 

Capture.PNG

Tags:

Comments

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!