Count Dates Within One Year of Today in Excel
Question details
Count dates in an Excel table from today through the same date one year from today.

- Product
- Microsoft Excel
- Device & OS
- not provided
- Scenario
- The user needs a count that updates as the current date changes.
- Observed behavior
- The desired count includes dates from today through the date one year later.
Check that the entries in your date column are recognized as Excel dates rather than text. Identify the table name and date column header so you can use them in the formula.
Use SUMPRODUCT to count dates over the next year
Use this formula to count table dates from today through the same date one calendar year later.
Click an empty cell where you want the date count to appear.
Enter =SUMPRODUCT((Table134[Date]>=TODAY())*(Table134[Date]<EDATE(TODAY(),12)+1)), replacing Table134 and Date with your table name and date column header.
Press Enter. The formula includes today and the entire date one year later, even if entries contain times.

Count upcoming dates in WPS Spreadsheet
Use SUMPRODUCT, TODAY, and EDATE in WPS Spreadsheet to count dates from today through one year from today.
- 1. Open the spreadsheet: Open WPS Spreadsheet and select Open to load your Excel file.
- 2. Locate the dates: Find the cells containing your dates, such as A2:A1000, and click an empty result cell.
- 3. Enter the formula: Type =SUMPRODUCT((A2:A1000>=TODAY())*(A2:A1000<EDATE(TODAY(),12)+1)), replacing A2:A1000 with your date range.
- 4. Save the result: Press Enter to calculate the count, then use File > Save As to save the spreadsheet.

Frequently Asked Questions
Does the formula include today and the date one year from today?
Yes. The >=TODAY() condition includes today, and the <EDATE(TODAY(),12)+1 condition includes the entire final date.
How can I count dates in the preceding year instead?
Use =SUMPRODUCT((Table134[Date]>=EDATE(TODAY(),-12))*(Table134[Date]<TODAY()+1)), replacing the table and column names as needed. This includes today.
Why is my date count not updating?
In Excel, check Formulas > Calculation Options and select Automatic. You can also press F9 to recalculate the workbook.
What if the dates are stored as text?
Convert the entries to recognized Excel dates before counting them. For example, select the column and use Data > Text to Columns to convert consistently formatted date text.




