The DAYS function calculates the number of days between two dates in Excel. It is a simple yet essential function for determining the duration between specific points in time.


=DAYS(End_date, Start_date)

End_date The end date of the period.
Start_date The start date of the period.

About DAYS

When you need to quickly find out the number of days elapsed between two dates, the DAYS function in Excel comes to the rescue. It swiftly calculates the duration in days, aiding in various scenarios like project timelines, financial calculations, or simply tracking events over time.


If you have the start date as 15th January 2022 and the end date as 25th January 2022, you can find out the number of days between them using the DAYS function as follows: =DAYS("1/25/2022", "1/15/2022"). This will return 10 since there are 10 days between these two dates.

For a longer duration, consider the start date as 1st January 2022 and the end date as 31st March 2022. Compute the number of days between them with: =DAYS("3/31/2022", "1/1/2022"). This will give you 89 days.

If you desire to track the duration from today until a future date, you can use the TODAY function in combination with DAYS. For instance, if you want to know the days left until 1st July 2022, the formula would be: =DAYS("7/1/2022", TODAY()).


How does the DAYS function determine the number of days between two dates?

The DAYS function calculates the days by simply subtracting the start date from the end date. This results in the total number of days between the two dates.

Can the DAYS function handle dates in different formats or date serial numbers?

Yes, the DAYS function is versatile and can work with dates in various formats as long as they are recognized as valid Excel date values. It can also process date serial numbers directly to compute the day difference.

Is the DAYS function suitable for calculating durations beyond simple calendar days?

While the DAYS function is primarily used for calculating the elapsed days between dates, it can be adapted to measure durations in terms of days for various purposes, including project schedules, interest accrual periods, or event intervals.

Related functions