DAYS function
Summary
Returns the number of days between two dates
Syntax
DAYS(end_date, start_date)
The DAYS function syntax has the following arguments.
• End_date Required. Start_date and End_date are the two dates between which you want to know the number of days.
• Start_date Required. Start_date and End_date are the two dates between which you want to know the number of days.
Note: Excel stores dates as sequential serial numbers so that they can be used in calculations. By default, Jan 1, 1900 is serial number 1, and January 1, 2008 is serial number 39448 because it is 39447 days after January 1, 1900.
• End_date Required. Start_date and End_date are the two dates between which you want to know the number of days.
• Start_date Required. Start_date and End_date are the two dates between which you want to know the number of days.
Note: Excel stores dates as sequential serial numbers so that they can be used in calculations. By default, Jan 1, 1900 is serial number 1, and January 1, 2008 is serial number 39448 because it is 39447 days after January 1, 1900.
Example
=DAYS("15-MAR-2021","1-FEB-2021")
=DAYS(A2,A3)
=DAYS(A2,A3)