Avatar of Pau Lo
Pau Lo
 asked on

month statistic count formula

Is there a particular function in Excel that may help with the following.
I have 3 columns of data (A, B and C) and the data is formatted as dates, dd/mm/yyyy.
There are approximately 2000 records/rows.
I need to create an analysis formula in column D, that checks all of the date values per row/record, and creates a summary of how many of those entries for that row were during March 2021. I can do it manually with a color coding system + auto-filter approach, but a formula would be better in case the next extract of data is larger.

For example:

If cell A2 was 01/03/2021, cell B2 was 01/04/2021, and cell C2 was 01/05/2021, then the formula would produce "1", as only one of those cells for that row represented a date during March.

Whereas if cell A3 was 02/03/2021, cell B3 was 05/03/2021, and cell C3 was 10/03/2021, the formula would produce "3", as all three of those cells for that row represent a date during March. 
Microsoft ExcelMicrosoft Office

Avatar of undefined
Last Comment
Rob Henson

8/22/2022 - Mon
ASKER CERTIFIED SOLUTION
Subodh Tiwari (Neeraj)

THIS SOLUTION ONLY AVAILABLE TO MEMBERS.
View this solution by signing up for a free trial.
Members can start a 7-Day free trial and enjoy unlimited access to the platform.
See Pricing Options
Start Free Trial
GET A PERSONALIZED SOLUTION
Ask your own question & get feedback from real experts
Find out why thousands trust the EE community with their toughest problems.
Rob Henson

Another option would be COUNTIFS

=COUNTIFS(A2:C2,">="&DATE(2021,3,1),A2:C2,"<="&DATE(2021,3,31))
Experts Exchange has (a) saved my job multiple times, (b) saved me hours, days, and even weeks of work, and often (c) makes me look like a superhero! This place is MAGIC!
Walt Forbes