Count per month/year automatically

Lynn Collier

What formula do I use to count data per month/year and have it update automatically with new entries. How do I pull that rolling  data for past 12 month data to dashboard 

Bassam Khalil

Hi @Lynn Collier 

Hope you are fine, please find in the following the formula to count by month for November for example

=COUNTIFS([Column2]:[Column2], <=DATE(2020, 11, 30)) - COUNTIFS([Column2]:[Column2], <=DATE(2020, 11, 1))

and if you want count for 2020 you can use the formula

=COUNTIFS([Column2]:[Column2], <=DATE(2020, 12, 31)) - COUNTIFS([Column2]:[Column2], <=DATE(2020, 1, 1))

check the following screen shot for the sample

Bassam Khalil

Hi @Lynn Collier 

Did my post(s) help or answer your question or solve your problem? Please help the Community by marking it as the accepted answer/helpful. It will make it easier for others to find a solution or help to answer!

Lynn Collier

Hi, Sorry for the delay in getting back to you. The first formula works so that I do not have to put in a filler column of first and last day of the month. Thank you Lynn