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


DATEDIF function ( 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 ( most probably shall be available on all channels for Microsoft 365, includes semi-annual. But I'm not sure about Office 365.