Easiest way to calc "Months Ago" using Math Column

Here’s a handy little calc to find the number of months ago from a date column. This allows you to then create filters for this month, last month, next month, etc. I’m sure the more experienced users have already done this, so this might be more for those who are newer users. I like to keep my tables as lean as I can make them and this seems to be the leanest way to do this rather than a new query for each of these filters.

The formula is (YEAR(today)-YEAR(date column))*12+1-MONTH(date column). Positive numbers indicate dates in the past and negative are in the future.

6 Likes