Table of Contents
Google Sheets is a powerful tool that allows users to easily calculate the number of days between a specific date and today’s date. This can be done by using the built-in functions and formulas available in Google Sheets. Simply input the specific date and the TODAY function to automatically calculate the number of days between the two dates. This feature is useful for planning and organizing tasks, as well as keeping track of important dates. With its user-friendly interface and quick calculation capabilities, Google Sheets is an efficient way to determine the number of days between any two dates.
Google Sheets: Calculate Days Between Date and Today
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.
The following tutorials explain how to perform other common tasks in Google Sheets:
Cite this article
stats writer (2024). How can I use Google Sheets to calculate the number of days between a specific date and today’s date?. PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/how-can-i-use-google-sheets-to-calculate-the-number-of-days-between-a-specific-date-and-todays-date/
stats writer. "How can I use Google Sheets to calculate the number of days between a specific date and today’s date?." PSYCHOLOGICAL SCALES, 27 Jun. 2024, https://scales.arabpsychology.com/stats/how-can-i-use-google-sheets-to-calculate-the-number-of-days-between-a-specific-date-and-todays-date/.
stats writer. "How can I use Google Sheets to calculate the number of days between a specific date and today’s date?." PSYCHOLOGICAL SCALES, 2024. https://scales.arabpsychology.com/stats/how-can-i-use-google-sheets-to-calculate-the-number-of-days-between-a-specific-date-and-todays-date/.
stats writer (2024) 'How can I use Google Sheets to calculate the number of days between a specific date and today’s date?', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/how-can-i-use-google-sheets-to-calculate-the-number-of-days-between-a-specific-date-and-todays-date/.
[1] stats writer, "How can I use Google Sheets to calculate the number of days between a specific date and today’s date?," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, June, 2024.
stats writer. How can I use Google Sheets to calculate the number of days between a specific date and today’s date?. PSYCHOLOGICAL SCALES. 2024;vol(issue):pages.