troubleshooting Question

month statistic count formula

Avatar of Pau Lo
Pau Lo asked on
Microsoft ExcelMicrosoft Office
2 Comments1 Solution8 ViewsLast Modified:
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. 
Join our community to see this answer!
Unlock 1 Answer and 2 Comments.
Start Free Trial
Learn from the best

Network and collaborate with thousands of CTOs, CISOs, and IT Pros rooting for you and your success.

Andrew Hancock - VMware vExpert
See if this solution works for you by signing up for a 7 day free trial.
Unlock 1 Answer and 2 Comments.
Try for 7 days

”The time we save is the biggest benefit of E-E to our team. What could take multiple guys 2 hours or more each to find is accessed in around 15 minutes on Experts Exchange.

-Mike Kapnisakis, Warner Bros