Calculation Issues

How to Automatically Count Days Since a Start Date in Excel

Steven ParkerSteven Parker Nov 10, 2026 870 views

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.

How to Automatically Count Days Since a Start Date in Excel
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.
Before you start

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.

Solution 1Recommended

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.

1
Enter the Start Date

Store the starting date for your records in a specific column, for example, cell T2.

2
Input the TODAY Formula

Select the cell where you want to display the elapsed days (such as cell B2). Type the formula =TODAY()-T2 and press Enter.

3
Format as Number

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.

4
Fill the Formula Down

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.

Calculate Elapsed Days Using the TODAY Function
Enable Automatic Calculation: To ensure the dates refresh properly upon opening, go to the Formulas tab, click Calculation Options, and ensure 'Automatic' is checked.
Powerful Spreadsheet Capabilities

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. 1. Open your workbook: Launch WPS Spreadsheet and open the document containing your dates.
  2. 2. Enter the formula: Select your target cell, type =TODAY()-T2 (assuming T2 is your start date), and press Enter.
  3. 3. Adjust cell formatting: Right-click the cell, choose 'Format Cells', and select 'Number' to display the result as days.
  4. 4. Apply to multiple rows: Drag the bottom-right corner of the selected cell to fill the formula down the column.
Perfect compatibility with Microsoft Excel (.xlsx) formats and formula structures.Built-in date and time functions for dynamic project tracking and scheduling.Free, lightweight, and fast to open on any device.Intuitive interface with familiar automatic calculation options.
microsoft office alternative - wps office

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).