DATEDIF - Save yourself some time and time functions
To me it is DAT-DIF i.e. “date differential” and not DATED-IF as I don’t think this formula meant to solve conditional arguments.
Though this function is meant for compatibility purposes and is so hidden/ignored that even if you type it in Excel you won’t see any tooltip for this formula or function. It is the simplicity of this function that I love it especially if one is calculating difference between dates and doing ageing analysis or simply calculating age of asset/instrument or humans.
