Table of Contents
Excel is a powerful tool for performing calculations, including determining the number of days between a given date and today’s date. To do so, one can use the built-in function “TODAY()” to retrieve today’s date, and then use the “DAYS()” function to subtract the given date from the current date. This will result in the number of days between the two dates. This feature can be useful in various scenarios, such as tracking deadlines, monitoring project timelines, or planning future events. By utilizing Excel’s functions, one can easily and accurately calculate the number of days between any two dates.
Excel: Calculate Days Between Date and Today
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.
The following tutorials explain how to perform other common tasks in Excel:
Cite this article
stats writer (2024). How can I use Excel to calculate the number of days between a given date and today’s date?. PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/how-can-i-use-excel-to-calculate-the-number-of-days-between-a-given-date-and-todays-date/
stats writer. "How can I use Excel to calculate the number of days between a given date and today’s date?." PSYCHOLOGICAL SCALES, 23 Jun. 2024, https://scales.arabpsychology.com/stats/how-can-i-use-excel-to-calculate-the-number-of-days-between-a-given-date-and-todays-date/.
stats writer. "How can I use Excel to calculate the number of days between a given date and today’s date?." PSYCHOLOGICAL SCALES, 2024. https://scales.arabpsychology.com/stats/how-can-i-use-excel-to-calculate-the-number-of-days-between-a-given-date-and-todays-date/.
stats writer (2024) 'How can I use Excel to calculate the number of days between a given date and today’s date?', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/how-can-i-use-excel-to-calculate-the-number-of-days-between-a-given-date-and-todays-date/.
[1] stats writer, "How can I use Excel to calculate the number of days between a given date and today’s date?," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, June, 2024.
stats writer. How can I use Excel to calculate the number of days between a given date and today’s date?. PSYCHOLOGICAL SCALES. 2024;vol(issue):pages.