We have a worksheet with a number of dates. I would like a formula to automatically calculate a date

Options

We have a worksheet with a number of dates. I would like a formula to automatically calculate a date 6 weeks before a date in anothor cell? Ie. If "FYE Date" is 28.02 or 29.02 then "start date" = "FYE Date" - 6 weeks. Is this possible?

Best Answer

Answers

Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!