In this case, we want days ignoring years so we supply “yd” for unit.
(For the full list of options, see theDATEDIFpage).
Once configured, the function is fully automatic and returns a result in the unit requested.
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…
