Forum Discussion
PWWRB
Oct 07, 2022Copper Contributor
DATEDIF Giving incorrect data
I have a colleague who is doing some salary work. The formula's work until the random one throws up errors and we cannot figure out why. The only fix is to insert a fresh new row into the excel and m...
Riny_van_Eekelen
Oct 07, 2022Platinum Contributor
PWWRB This is what MS writes about DATEDIF in their support pages:
Warning: Excel provides the DATEDIF function in order to support older workbooks from Lotus 1-2-3. The DATEDIF function may calculate incorrect results under certain scenarios. Please see the known issues section of this article for further details.
Without some example data it's difficult to tell why it sometimes goes wrong for you. Can you upload or share a file with data that include the incorrect results?