For example, the formula =DAYS360(“1-Jan-2021”,“31-Dec-2021”) returns 360 days.

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…

Excel formula: Get months between dates

Excel formula: Get age from birthday

Excel formula: Calculate retirement date

Excel formula: Get percent of year complete

Excel formula: Calculate years between dates

Article image

Article image

Article image

Excel DAYS360 function

Excel DATEDIF function