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)



ADVERTISEMENT
ADVERTISEMENT