Calculation Issues

Count Dates Within One Year of Today in Excel

Maira MehtabMaira Mehtab Nov 18, 2026 869 views

Question details

Count dates in an Excel table from today through the same date one year from today.

Count Dates Within One Year of Today in Excel
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.
Before you start

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.

Solution 1Recommended

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.

1
Select a result cell

Click an empty cell where you want the date count to appear.

2
Enter the formula

Enter =SUMPRODUCT((Table134[Date]>=TODAY())*(Table134[Date]<EDATE(TODAY(),12)+1)), replacing Table134 and Date with your table name and date column header.

3
Calculate the count

Press Enter. The formula includes today and the entire date one year later, even if entries contain times.

Use SUMPRODUCT to count dates over the next year
Calendar year versus 365 days: EDATE(TODAY(),12) uses a 12-month calendar interval. For a fixed 365-day interval, use TODAY()+365 as the end date instead.
Count dates in WPS Spreadsheet

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. 1. Open the spreadsheet: Open WPS Spreadsheet and select Open to load your Excel file.
  2. 2. Locate the dates: Find the cells containing your dates, such as A2:A1000, and click an empty result cell.
  3. 3. Enter the formula: Type =SUMPRODUCT((A2:A1000>=TODAY())*(A2:A1000<EDATE(TODAY(),12)+1)), replacing A2:A1000 with your date range.
  4. 4. Save the result: Press Enter to calculate the count, then use File > Save As to save the spreadsheet.
Create a count that updates with the current dateInclude date-and-time entries through the end of the final dayOpen and save Microsoft Excel XLSX files
microsoft office alternative - wps office

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.