RagDyeR,

For seniority, simply finding the earliest (least) start date should be
sufficient: If I started before you, then I am senior to you.

HTH,
Bernie
MS Excel MVP


"RagDyeR" wrote in message
...
About to start out on a seniority project for the plants.

If this was 3 months ago, I wouldn't have given a second thought about
using
Datedif.

However, in the past couple of weeks, I've read, and been part of threads
where the inconsistencies of the function have been brought to light.

Of course, seniority will range over the full gamut of time, from days to
years.

Would you please just share with me your opinion on the function?

Would YOU use it ... or not?


TIA,

RD