Excel DAYS() Function
The DAYS() function in excel returns the number of days that exist between two dates.
Syntax
DAYS (end_date, start_date)
Parameter
end_date (required)- This parameter represents the end date.
start_date (required)- This parameter represents the start date.
Category
Date & Time
Return
This function returns the number of days between two dates.
Example 1
Objective: Get the total workdays between 'State Date' and 'End Date'
Start Date | End Date | Result | Formula Used |
1-Jan-18 | 30-Jun-18 | 180 | =Date(A2,B2) |
11-Apr-16 | 1-Jan-18 | 630 | =Date(A3,B3) |
17-Feb-18 | 12-Sep-18 | 207 | =Date(A4,B4) |
18-Jul-18 | 18-Jul-18 | 0 | =Date(A5,B5) |