Count Formula-Generated Dates by Month in Excel with COUNTIFS
Question details
Count formula-generated dates in a given month while also matching a value in another column.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- Column G contains calculated dates, column F contains values to match, and T28 identifies the month to count.
- Observed behavior
- The desired count includes rows matching I29 in column F and any valid date in the month represented by T28.
Check that G1:G474 and F1:F474 cover corresponding rows and that T28 contains a real Excel date in the month you want to count. In an empty cell, use =ISNUMBER(G1) and =ISNUMBER(T28) to check for numeric values; format numeric values as dates to verify they represent the intended dates.
Count the Entire Month with COUNTIFS and EOMONTH
Use a date range to count all dates in T28's month, including dates with time values.
Excel stores valid dates as numbers, so COUNTIFS can evaluate dates returned by formulas. The range starts on the first day of the month and ends before the first day of the next month.
Click the cell where you want the monthly count to appear.
Enter =COUNTIFS($F$1:$F$474,$I29,$G$1:$G$474,">="&(EOMONTH(T$28,-1)+1),$G$1:$G$474,"<"&(EOMONTH(T$28,0)+1)) and press Enter.
Confirm that I29 contains the value to match in column F and T28 contains a date in the target month. Adjust the ranges if your data extends beyond row 474.

Count an Exact Date with COUNTIFS
Use this formula when you need to match the exact date in T28 rather than the whole month.
Count Monthly Dates with COUNTIFS in WPS Spreadsheets
Open your spreadsheet in WPS Spreadsheets and use COUNTIFS with EOMONTH to count formula-generated dates within a month.
- 1. Open the workbook: Open WPS Spreadsheets and use Open to select your Excel workbook.
- 2. Check the criteria: Confirm that I29 contains the value to match in column F and T28 contains a valid date in the target month.
- 3. Enter the count formula: Select the result cell and enter =COUNTIFS($F$1:$F$474,$I29,$G$1:$G$474,">="&(EOMONTH(T$28,-1)+1),$G$1:$G$474,"<"&(EOMONTH(T$28,0)+1)).
- 4. Calculate and save: Press Enter to calculate the count, then use File > Save to save the workbook.

Frequently Asked Questions
Can COUNTIFS count dates returned by formulas?
Yes. COUNTIFS evaluates the formula results in the criteria range. The results must be numeric date values for the monthly date-range formula to work reliably.
Why does an exact date match miss some rows?
A date in column G may contain a time that differs from T28. Enter =MOD(G1,1) in an empty cell to check for a time component, or use the monthly range formula to include all times in the month.
Does T28 have to be the first day of the month?
No. T28 can contain any valid date in the target month. EOMONTH calculates the boundaries of that month from it.
How can I tell whether a date is stored as text?
Enter =ISNUMBER(G1) in an empty cell. FALSE means the result is not numeric; TRUE means it is numeric, so format the cell as a date and verify that it represents the intended date.




