You can use the following basic formula to calculate the number of days between a given date and today in Google Sheets:

=DATEDIF(A1, Today(), "D")

This particular formula calculates the number of days between today and the date in cell **A1**.

**Note**: The “D” tells Google Sheets to calculate the difference in days as opposed to some other unit of measurement 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 Google Sheets**

Suppose we have the following dataset in Google Sheets:

Note that this article is currently being written on **7/26/2022**.

Thus, I can type the following formula into cell C2 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 C:

Column C now displays the number of days between today and the dates in column A.

For example:

- There are
**937**days between 7/26/2022 and 1/1/2020. - There are
**813**days between 7/26/2022 and 5/4/2020. - There are
**772**days between 7/26/2022 and 6/14/2020. - There are
**600**days between 7/26/2022 and 12/3/2020.

And so on.

**Additional Resources**

The following tutorials explain how to perform other common tasks in Google Sheets:

How to Sum by Year in Google Sheets

How to Sum by Month in Google Sheets

How to Sort by Date in Google Sheets