Help with 6 month rolling summary metrics

I have a date column in a sheet and I am looking to count the number of dates that fall within the current, then current month +1, current month +2, so on a so forth. I think the tricky part is making sure the counts are accurate based on year as well. So since today is October 2, 2021 the rolling 6 months would be as follows:

October 2021 - Current Month

November 2021 - Current Month +1

December 2021 - Current Month +2

January 2022 - Current Month + 3

February 2022 - Current Month +4

So on and so forth...

Any help is greatly appreciated!


Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!