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.

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

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.

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