DATEDIF - DATEDIF Calculation returning a negative for days or months

Hi all,

I'm looking for some help with subtracting a range of dates, from another range of dates using datedif formula.

The issue is that the end result is producing a negative number of days (-9 in this example) or months in cell E11.

Is there any way to accurately subtract a larger number of dates from a smaller, thereby reducing the months by one?

The example has an employees period of employment being reduced by a range which doesn't count as service.

Any help would be appreciated.

Thanks

David

One approach:

Calculate all date differences as days for both PTS and Leave rows 3 to 7) - could use "helper" columns.

Sum all values for each and use formula below; (in my example A17 contains SUM(PTS) -SUM(Leave)


=DATEDIF(0,A17,"y")&" years " &DATEDIF(0,A17,"ym")&" months "&DATEDIF(0,A17,"md")&" days"

This is the result from your data: 2 years 11 months 24 days

Hi John, thanks for the help, is there any chance you could provide a sample file showing the calc?

Cheers

David

See attached.

If your problem is resolved could you mark the thread as SOLVED ("thread Tools" on first post header).

Thank you.

Thanks John, much appreciated. I'll close the post.