Backdate into Last Year

Smartsheet User 99 · 04/05/22

Trying to backdate 6 months or 180 days from a specified date.

I'm able to go back 6 months without any issues, but I want to return that date for the 1st day of the month.

=DATE(YEAR([1st day]@row), MONTH([1st day]@row), 1) - 180

If it backdates into last year, it doesn't go to last year and instead changes it to the current year.

=DATE(YEAR([1st day]@row), MONTH([1st day]@row-180), 1)

I'm pretty sure I'm missing something simple, but can't figure it out. Please help. Thank You.

Paul Newcome · 04/06/22

Also subtract 180 from the date in the YEAR function.

Paul Newcome · 04/06/22

Also subtract 180 from the date in the YEAR function.

Smartsheet User 99 · 04/06/22

thank you so much. Such a simple solution.

Paul Newcome · 04/07/22

Happy to help. 👍️

Best Answer