WorksheetFunction.Days (Excel)

Returns the number of days between two dates.

Days (Arg1, Arg2)

Dim dblDays As Double
dblDays = WorksheetFunction.Days(Arg1:=, Arg2:=)

Arguments

Arg1 - start_date(Arg2) and end_date (Arg1) are the two dates between which you want to know the number of days

Arg2 - start_date(Arg2) and end_date (Arg1) are the two dates between which you want to know the number of days