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.
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.