You can use the following formula to calculate the number of days between a given date and today in Excel:
=DATEDIF(A1, TODAY(), "D")
This particular formula calculates the number of days between today and the date in cell A1.
Note: The “D” tells Excel to calculate the difference in days as opposed to some other unit of time like “M” for months or “Y” for years.
The following example shows how to use this formula in practice.
Example: Calculate Days Between Date and Today in Excel
Suppose we have the following list of dates in Excel:
Note that this article is currently being written on 5/7/2023.
I can type the following formula into cell B2 to calculate the difference between the date in cell A2 and today:
=DATEDIF(A2, TODAY(), "D")
We can then drag and fill this formula down to each remaining cell in column B:
Column B now displays the number of days between today and the dates in column A.
- There are 1,222 days between 5/7/2023 and 1/1/2020.
- There are 1,087 days between 5/7/2023 and 5/15/2020.
- There are 1,054 days between 5/7/2023 and 6/17/2020.
- There are 964 days between 5/7/2023 and 9/15/2020.
And so on.
The following tutorials explain how to perform other common tasks in Excel:
Excel: How to Check if Cell Contains Date
Excel: How to Get Date from Week Number
Excel: How to Convert Date to YYYYMMDD Format