Table of Contents
The DAYS function is a useful tool in Google Sheets that allows users to calculate the number of days between two given dates. To use this function, simply enter the start date and end date in the proper format, separated by a comma. The result will be displayed as a number representing the total number of days between the two dates. This function is especially handy for tracking project timelines, calculating interest rates, and other time-sensitive calculations. By using the DAYS function in Google Sheets, users can easily and accurately calculate the number of days between any two dates.
DAYS function
The DAYS function returns the number of days between two dates.
Parts of a DAYS function
DAYS(end_date,start_date)
| Part | Description | Notes |
end_date | The end of the date range. | |
start_date | The start of the date range. |
Sample formulas
DAYS("7/24/1969", "7/16/1969")
DAYS(“2/28/2016”, “2/28/2017”)
Notes
The DAYS function factors in leap days.
Examples
The below example shows the difference between two days in the same month.
| A | B | |
| 1 | Formula | Result |
| 2 | =DAYS("7/24/1969", "7/16/1969") | 8 |
The below example shows the difference between two dates factoring in a leap day:
| A | B | |
| 1 | Formula | Result |
| 2 | =DAYS(“2/28/2016”, “2/28/2017”) | 366 |
Related functions
- DAY: Returns the day of the month that a specific date falls on, in numeric format.
- DAYS360: Returns the difference between two days based on the 360-day year used in some financial interest calculations.
- NETWORKDAYS: Returns the number of net working days between two provided days.
Cite this article
stats writer (2024). How do I use the DAYS function in Google Sheets?. PSYCHOLOGICAL SCALES. Retrieved from https://scales.arabpsychology.com/stats/how-do-i-use-the-days-function-in-google-sheets/
stats writer. "How do I use the DAYS function in Google Sheets?." PSYCHOLOGICAL SCALES, 28 Jun. 2024, https://scales.arabpsychology.com/stats/how-do-i-use-the-days-function-in-google-sheets/.
stats writer. "How do I use the DAYS function in Google Sheets?." PSYCHOLOGICAL SCALES, 2024. https://scales.arabpsychology.com/stats/how-do-i-use-the-days-function-in-google-sheets/.
stats writer (2024) 'How do I use the DAYS function in Google Sheets?', PSYCHOLOGICAL SCALES. Available at: https://scales.arabpsychology.com/stats/how-do-i-use-the-days-function-in-google-sheets/.
[1] stats writer, "How do I use the DAYS function in Google Sheets?," PSYCHOLOGICAL SCALES, vol. X, no. Y, ص Z-Z, June, 2024.
stats writer. How do I use the DAYS function in Google Sheets?. PSYCHOLOGICAL SCALES. 2024;vol(issue):pages.