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.

For example:

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

**Additional Resources**

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