Forum Discussion
asrobich
May 15, 2020Copper Contributor
Problem with DATEDIF function
Hi. I'm trying to calculate the difference between two dates in Excel. I have used the DATEDIF function to do this in the past, but it doesn't seem to be working correctly this time. Instead of re...
9606806084
Jul 29, 2022Copper Contributor
Riny_van_Eekelen I have a problem in using datedif ,it's not giving total experience properly, Example: it's giving only 5.1 or 5.9 (here 5 stand for year 1 stand for month, it's same with other mentioned results),it's not generating results as 5.11 year ,I request someone to assist me on this
Riny_van_Eekelen
Jul 29, 2022Platinum Contributor
9606806084 You need to clarify and give more detail. DATEDIF is not an official Excel function and know to to give wring results in certain circumstances, what's your formula? How does the underlying data look like?