Office 365 Excel functions DATEDIF and XLOOKUP not available

Occasional Visitor

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.

1 Reply

@trevorzglobaldd 

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.