Calculation Issues

Count Formula-Generated Dates by Month in Excel with COUNTIFS

Bushra ParveenBushra Parveen Nov 18, 2026 870 views

Question details

Count formula-generated dates in a given month while also matching a value in another column.

Count Formula-Generated Dates by Month in Excel with COUNTIFS
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.
Before you start

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.

Solution 1Recommended

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.

1
Select the result cell

Click the cell where you want the monthly count to appear.

2
Enter the monthly count formula

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.

3
Check the references

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 the Entire Month with COUNTIFS and EOMONTH
Formula results must be dates: Dates returned as text are not reliable date values for this range comparison. Check the formulas in column G if they return text instead of numeric date serials.
Count dates in WPS Spreadsheets

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. 1. Open the workbook: Open WPS Spreadsheets and use Open to select your Excel workbook.
  2. 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. 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. 4. Calculate and save: Press Enter to calculate the count, then use File > Save to save the workbook.
Count dates across a full month, including values with timesOpen and edit Microsoft Excel XLSX filesUse familiar spreadsheet formulas and cell referencesWork with spreadsheets in a free, easy-to-use office suite
microsoft office alternative - wps office

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.