Formula to count the number of sessions completed dates per month includes varying months.

Aimee E.

I have a column on my spreadsheet that tracks the dates of all sessions that have completed. I am trying to figure the formula to tell me how sessions many were completed by month. I am super new to formulas. I really think I am over complicating it.

I have started a calculation sheet and have the months listed by column as such:

Jan

Feb

March

April etc.....

I want to tie these back to a Dashboard.

Any assistance would be so helpful...

Nick Korna

Hi @Aimee E. ,

In the sheet to count completed sessions create columns with Month, Month# (and if using multiple years of data, a column for Year) to end up with something like this:

If you're using a single year of data, then the count can be done with the following formula:

=COUNTIFS({Sessions Range 1}, IFERROR(MONTH(@cell), 0) = [Month#]@row)

Where your {Sessions Range 1} would be looking at the column containing your completed dates, such as this:

If you want data spread over multiple years, you can use the below formula instead:

=COUNTIFS({Sessions Range 1}, IFERROR(MONTH(@cell), 0) = [Month#]@row, {Sessions Range 1}, IFERROR(YEAR(@cell), 0) = Year@row)

This will count up matches by both month & year. Example showing both (using the data shown above):

You can then use a Row Report for the data for a dashboard etc.

Hope this helps - if you've any questions just ask!