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

Andre de Oliveira

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?

Genevieve P.

Hi Andre,

As long as the FYE Date is a Date Type of column, this should be no problem! You can add or minus days from dates with a simple + or - sign.

So, since you're looking to work 6 weeks backwards, you would just need to minus 42 days (6 weeks) from the date in the FYE Date column.

Try this in a new Date Column:

=[FYE Date]@row - 42

Here's a Help Center article on using Dates in Formulas: https://help.smartsheet.com/articles/2477601-use-formulas-perform-calculations-dates

Cheers,

Genevieve

Genevieve P.

Hi Andre,

As long as the FYE Date is a Date Type of column, this should be no problem! You can add or minus days from dates with a simple + or - sign.

So, since you're looking to work 6 weeks backwards, you would just need to minus 42 days (6 weeks) from the date in the FYE Date column.

Try this in a new Date Column:

=[FYE Date]@row - 42

Here's a Help Center article on using Dates in Formulas: https://help.smartsheet.com/articles/2477601-use-formulas-perform-calculations-dates

Cheers,

Genevieve