How to Calculate Days Between Date and Today in Google Sheets

To calculate the days between a specific date and today in Google Sheets, you can use the DATEDIF or DAYS function.

Using the DATEDIF function:

1. Click on the cell where you want the result to appear.
2. Type the following formula: =DATEDIF(A1, TODAY(), "D")
   • Replace "A1" with the reference to the cell containing the specific date.
3. Press Enter.

Using the DAYS function:

1. Click on the cell where you want the result to appear.
2. Type the following formula: =DAYS(TODAY(), A1)
   • Replace "A1" with the reference to the cell containing the specific date.
3. Press Enter.

Both methods will return the number of days between the specific date and today.

Example

Let's say you have a specific date (e.g., 01/01/2020) in cell A1, and you want to calculate the days between that date and today in cell B1.

Using the DATEDIF function:

1. Click on cell B1.
2. Type the following formula: =DATEDIF(A1, TODAY(), "D")
3. Press Enter.

Using the DAYS function:

1. Click on cell B1.
2. Type the following formula: =DAYS(TODAY(), A1)
3. Press Enter.

Both methods will return the number of days between 01/01/2020 and today in cell B1.