The DAYS function belongs to a date function group, used to return results between two time points. With this DAYS function, calculating intervals is much easier, can be applied to many different cases. The following article will guide you how to use the DAYS function in Excel.
Syntax: = DAYS(end_date, start_date).
The AND 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.
Example: Let’s look at some Excel DAYS function examples and explore how to use the DAYS function as a worksheet function in Microsoft Excel:
Syntax: =DAYS(A2,B2)
Result: