Aug 15 2022 01:38 PM
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.
Aug 15 2022 03:05 PM
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.
Mar 23 2023 08:04 AM
I tried typing =DATEDIF(... and the parameters and get a #NAME? Error.
Mar 24 2023 09:29 AM
Mar 31 2023 07:13 AM
@Sergei Baklan 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.
Mar 31 2023 07:59 AM
SolutionMar 31 2023 09:50 AM
@Sergei Baklan Thank you for your help!
Apr 02 2023 02:09 AM
@CindyA123 , you are welcome
May 02 2023 06:37 AM
Apr 30 2024 07:35 AM
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.
Mar 31 2023 07:59 AM
SolutionNo, Excel doesn't support negative time and date directly. As workaround that could be