How to Automatically Count Days Since a Start Date in Excel
Question details
The user wants to display the number of elapsed days since a specific start date in a column, ensuring it updates automatically whenever the workbook is opened.

- Product
- Excel
- Device & OS
- not provided
- Scenario
- Tracking elapsed time or duration from a fixed past date to the current date dynamically.
- Observed behavior
- The goal is for the cell to automatically show the correct number of passed days based on the current system date upon opening the file.
Ensure your device's system clock is set to the correct date, as dynamic date formulas rely directly on your system's current time configuration.
Calculate Elapsed Days Using the TODAY Function
Use the TODAY function to subtract the start date from the current date. This method natively updates the day count every time the workbook is opened or recalculated.
The TODAY() function continuously fetches the current date from your operating system. By subtracting a past date from TODAY(), the spreadsheet returns the exact number of days between the two dates.
Store the starting date for your records in a specific column, for example, cell T2.
Select the cell where you want to display the elapsed days (such as cell B2). Type the formula =TODAY()-T2 and press Enter.
If the result displays as a date, right-click the cell, select 'Format Cells', choose 'Number' under the Category list, and set decimal places to 0.
Click and drag the fill handle at the bottom-right corner of cell B2 downwards to apply the formula to the rest of the column.

Easily Calculate Date Differences in WPS Spreadsheet
WPS Spreadsheet offers full support for dynamic date functions like TODAY and DATEDIF, allowing you to track elapsed days seamlessly. It is a lightweight, free alternative fully compatible with standard Excel formulas.
- 1. Open your workbook: Launch WPS Spreadsheet and open the document containing your dates.
- 2. Enter the formula: Select your target cell, type =TODAY()-T2 (assuming T2 is your start date), and press Enter.
- 3. Adjust cell formatting: Right-click the cell, choose 'Format Cells', and select 'Number' to display the result as days.
- 4. Apply to multiple rows: Drag the bottom-right corner of the selected cell to fill the formula down the column.

Frequently Asked Questions
Why is my formula showing a date instead of a number of days?
Spreadsheet software often inherits the date formatting from the referenced start date cell. To fix this, right-click the cell containing your formula, select 'Format Cells', and change the category from 'Date' to 'Number' or 'General'.
Does the TODAY function update constantly while the workbook is open?
The TODAY function updates whenever the worksheet recalculates, such as when you edit a cell, press F9, or reopen the workbook. It does not tick continuously in real-time like a live digital clock.
Can I use the DATEDIF function instead to calculate days?
Yes, you can use the formula =DATEDIF(T2, TODAY(), "d") to calculate the complete days elapsed between a start date in T2 and the current date. It serves the same purpose but strictly outputs the difference in days without changing the cell to date formatting automatically.
What if the start date is in the future?
If the start date is in the future, =TODAY()-T2 will return a negative number. To avoid negative days and display zero instead, you can wrap it in a MAX function: =MAX(0, TODAY()-T2).




