Diff between two dates formatted as years and months

G

Guest

I am trying to display an employee's length of service at a particular date
using a simple formula to subtract one date from the other and format the
result as y"y" m"m" so that I get eg. 2y 4m as the person's service.

It is returning odd results eg. 0y 12m for diff between 1/1/04 and 1/1/05
and 1y 1m for diff between 31/12/03 and 1/1/05.

Is there a more accurate method of doing this to ensure that I get the
result I want?

Thanks for all your help
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Summary of Difference between dates in years, months, days 3
Calculating Years and Months Between Dates 2
COUNTIF between dates and if value = "y" 8
Calculating a week between a range of dates 3
Calculating time between mulitple dates 4
Difference between dates returning full months and remaining days 5
formula for calculating repeat occurences between specified dates 4
count occurrence between two specific dates 1

Top