Calculating date difference

[rll]

Hi

I need to calculate the number of years of service for
person(difference between Start_Date & End_Date). The result should b
in terms of years, months and days (all in one single cell). Ca
someone please help?

Thanks

 

[Andy B]

Have a look at Chip's site:

http://www.cpearson.com/excel/datedif.htm

Andy.

 

[Paul]

Hi

I need to calculate the number of years of service for a
person(difference between Start_Date & End_Date). The result should be
in terms of years, months and days (all in one single cell). Can
someone please help?

Thanks!

The problem here is that months are not all the same length. Presumably you
would consider the difference between 1st Feb 2003 and 1st March 2003 as one
month. However, what about the difference between 1st Jan 2003 and 29th Jan
2003? This is the same period (28 days), but not a complete month. If you
can define exactly what you want in all such circumstances, perhaps someone
will have a chance of helping you achieve it.

 

[2rrs]

Give this a try:

=DATEDIF(A47,NOW(),"y")&" years, "&DATEDIF(A47,NOW(),"ym")&" months,
"&DATEDIF(A47,NOW(),"md")&" days"

This returns difference between date in A47 and "today" and will
change as the calendar day changes.
If you prefer you can substitute a 2nd cell ref with end_date for
"NOW()"

 

[rll]

It works! Thank you all for the kind assistance..