Forum Discussion
Custom function that is more accurate than worksheet function DateDif for calculating work experi.
Hi folks, Recently I needed to calculate work experience for some workers and I tried to use DateDif function but I noticed it isn't 100% accurate. For example If I have start date as Jan 1st 201...
FWIW, reading your post reminded me of my days in the early 1970s, working in HR, using an IBM 360 [I was working for Big Blue at the time].....for accuracy on multi-year queries and reports using SQL, we'd specify the length of a year as 365.25 days. Obviously that was to account for Leap Years.
So just now I did the current thing to verify....I asked Google. Here's the screen grab.
It does make me wonder how Excel factors this kind of precision into their functions.
Anybody know for sure?