Both dates must bevalid Excel datesor text values that can be parsed as dates.
The DAYS360 function only works with whole numbers, time values are ignored.
Method
DAYS360 takes an optional argument calledmethodthat can be set to either TRUE or FALSE.
Whenmethodis FALSE (default) DAYS360 uses a US method to compute days.
Ifmethodis set to TRUE, DAYS360 uses a European method to calculate days.
The result of 360 is based on 12 months * 30 days in each month.
Working with nativeExcel datesis a better approach.
NETWORKDAYS Function
The Excel NETWORKDAYS function calculates the number of working days between two dates.
NETWORKDAYS automatically excludes weekends (Saturday and Sunday) and canoptionallyexclude a list of holidays supplied as dates.
The DATEDIF (Date + Dif) function is a “compatibility” function that comes from Lotus 1-2-3.
Excel won’t help you fill out the arguments for DATEDIF like other functions, but it will work…
