Forum Discussion
Office 365 Excel functions DATEDIF and XLOOKUP not available
Hello good day - presently I unable to to see functions DATEDIF and XLOOKUP. Are these Add-ins features or how do I load? Yes, I have correctly uninstalled Office 365 the performed new installation. Thanks- regards.
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.
- Use DAX function
=DATEDIFF(Sheet no.[column no],Today(),Year)How that could help?
Returning result into the grid we need first add the source to the data model, next return as PivotTable or linked-back table using DAX query. Not very straightforward solution.
More important, if we use DATEDIFF in calculated column, it returns an error for entire column if in any row start date is more than end date. Which returns us to the initial question.
