Forum Discussion
Solved
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. ...
Use DAX function
=DATEDIFF(Sheet no.[column no],Today(),Year)
=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.