Backdate into Last Year


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.

Best Answer


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!