DAYS
Formulas / DAYSCalculate the number of days between dates.
=DAYS(end_date, start_date)
- end_date - required argument
- start_date - required argument
Examples
=DAYS("7/15/2016","7/1/2016")The DAYS function can be used to calculate the number of days between two dates. For example, to calculate the number of days between July 1, 2016 and July 15, 2016, the formula can be used. This will return 14 days.
=DAYS("1-Mar-21","2-Mar-21")+1The DAYS function can also be used to calculate the number of days between two dates and to adjust the result. For example, to calculate the number of days between March 1, 2021 and March 2, 2021, the formula can be used. This will return 2 days.
Need help with Formulas?
Summary
The DAYS function calculates the number of days between two dates, using two required arguments: end_date and start_date.
- The DAYS function returns the number of days between two dates, including the start date in the count.
- It also counts all days in a given period.
Frequently Asked Questions
What is the DAYS function?
The DAYS function is a mathematical function used to calculate the number of days between two dates.
How does the DAYS function work?
The DAYS function takes two dates as arguments and returns the number of days between those two dates. The function calculates the difference in days, not including the start date.
What is an example of the DAYS function?
For example, if you wanted to find the number of days between 15 October 2020 and 25 October 2020, you would use the DAYS function like this: DAYS(15/10/2020, 25/10/2020). The result would be 10, as there are 10 days between those two dates.
What are the limitations of the DAYS function?
- The days function can only calculate the difference between two dates, not the time interval.
- The function does not include the start date in the calculation.
Work smarter
Al is here to help. Leverage the latest models to
analyze spreadsheets, enrich data, and create reports.
Drop CSV