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