Calculating dynamic date formula
I am trying to work on a formula to show the latest month (ie last month). As we are receiving self-evaluation data at the end of the month, so now in January 2022, we should have received data for December 2021.
What formula should I use to always check the box for last month, especially when we are crossing over to the new year.
In the example above, We are in January 2022 now, it should check the box in row 1 in "Latest Month" column.
Initially I was using =IF(Mth@row = MONTH(TODAY()) - 1, 1)
But when crossing to the new year, this formula is "missing" something.
Can anyone help?
Help Article Resources
Check out the Formula Handbook template!