Forum Discussion

Copper Contributor

Aug 15, 2022

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. ...

Formulas and Functions

SergeiBaklan
Mar 31, 2023
CindyA123

No, Excel doesn't support negative time and date directly. As workaround that could be

datedif sample (1).xlsx10 KB

SergeiBaklan

Diamond Contributor

Mar 31, 2023

CindyA123

No, Excel doesn't support negative time and date directly. As workaround that could be

datedif sample (1).xlsx10 KB

Yayi_Chop07

Copper Contributor

Jul 14, 2024

SergeiBaklan mine brings back a date for some reason

PeterBartholomew1
Silver Contributor
Jul 14, 2024
Yayi_Chop07
That is simply 443 months (the correct answer) but the number formatting is 'Date' when it should be 'General'.