Forum Discussion
Office 365 Excel functions DATEDIF and XLOOKUP not available
DATEDIF function (microsoft.com) is practically in any version of Excel, but it is not shown in list of functions (see comment in above support post). Thus simply type in cell =DATEDIF(...
XLOOKUP function (microsoft.com) most probably shall be available on all channels for Microsoft 365, includes semi-annual. But I'm not sure about Office 365.
I tried typing =DATEDIF(... and the parameters and get a #NAME? Error.
SergeiBaklan Thank you for your download. It was very helpful in troubleshooting a similar issue I had. My error was #NUM!. Your formula worked, so I Googled #NUM error and found out that the dates have to be in (earlier date, later date) order. Fortunately, all my dates are progressive, but curious if =DATEDIF function can work if dates increase and decrease (resulting in a negative number of months). Again, thank you.
