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. ...
SergeiBaklan Thank you for your download. It was very helpful in troubleshooting a similar issue I had. My error was #NUM!. Your formula worked, so I Googled #NUM error and found out that the dates have to be in (earlier date, later date) order. Fortunately, all my dates are progressive, but curious if =DATEDIF function can work if dates increase and decrease (resulting in a negative number of months). Again, thank you.
That is simply 443 months (the correct answer) but the number formatting is 'Date' when it should be 'General'.
SergeiBaklan Thank you for your help!
CindyA123 , you are welcome
