Subtracting to Produce a Year, from Dates

[MsCake]

Hi all,

I have 3 dates that I am working with.
A date that I need to find the number of years from today (this is a date someone started with our company)....This I have accomplished by using the following =DATEDIF(D21,NOW(),"Y")&"years,"&DATEDIF(D21,NOW(),"ym")&"months"

Then I have 2 more cells with 2 different dates (a date that they took a leave, and the 2nd date - the date they returned from said leave) and I have accomplished this with the following =DATEDIF(I21,J21,"y")&"years,"&DATEDIF(I21,J21,"ym")&"months"

**I can make the first have the year and month as well with: =DATEDIF(D21,NOW(),"Y")&"years,"&DATEDIF(D21,NOW(),"ym")&"months"


What I am trying to ultimately accomplish is a year (months displaying is fine as well), which will give me the total number of years with our company less the amount of time on leave.

Any help would be greatly appreciated. I have tried a few things, but, amd not getting my desired result.

Thank you

 

[Worf]

Hi

 

[MsCake]

Thank you so much! It did exactly what I wanted/needed it to do.

 

[Worf]

You are welcome and thanks for the feedback.