Need help getting to 1.year and 2. month, 12 months ago

brunwynne

I am trying to setup a rolling 12 month helper sheet, but can't figure out the formula to see what the year was 12 months ago, what the month was 12 months ago.

Thanks for your suggestions.

Jason Tarpinian

You can use this formula in a date column, which will return a date value of one year ago:

=DATE(YEAR(TODAY()) - 1, MONTH(TODAY()), DAY(TODAY()))