Formulas

ejacksonBPT

Now it places "2024" in the cell

Paul Newcome

Your months in [Month Text] should start on row 1 if you are referencing the entire column. If you don't want them on row 1, you will need to specify those rows in the formula instead of the entire column.

ejacksonBPT

Hello, I'm back to this last 3 months thing if you can still help me…by the way - do you "get" anything for answering questions in this community or do you just do it out of the goodness of your heart lol?

this is what my metric sheet looks like? How would i know go about getting the calculations in here so I can chart it?

Paul Newcome

@ejacksonBPT All I "get" is the chance to learn something new every day whether that be a new approach, a new mindset, a new little trick, etc.. I have learned (and continue to learn) so much from this community that I do what I can to give back.

As for getting the counts, I would suggest starting with the COUNTIFS listed in my previous post.

=COUNTIFS({Date Range}, AND(IFERROR(MONTH(@cell), 0) = IF(MONTH(TODAY()) <= Number@row, (12 - Number@row) + MONTH(TODAY()), MONTH(TODAY()) - Number@row), IFERROR(YEAR(@cell), 0) = YEAR(TODAY()) - IF(MONTH(TODAY()) <= Number@row, 1)))