Link to home
Create AccountLog in
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. 
ASKER CERTIFIED SOLUTION
Avatar of Subodh Tiwari (Neeraj)
Subodh Tiwari (Neeraj)
Flag of India image

Link to home
membership
Create a free account to see this answer
Signing up is free and takes 30 seconds. No credit card required.
See answer
Another option would be COUNTIFS

=COUNTIFS(A2:C2,">="&DATE(2021,3,1),A2:C2,"<="&DATE(2021,3,31))