DAYS

Formulas / DAYS
Calculate 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")+1

    The 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.

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.

Make Better Decisions
With Data

Analyze data, automate reports and create live dashboards
for all your business applications, without code. Get unlimited access free for 14 days.