Bjair wrote:
I want to calculate employment service and have it display as
year/month/day. Example: If I worked from 2/18/85 - 8/1/06 my service
would be 21/5/12.
Hi Bjair,
You can use the DATEDIF function, an old Lotus 1-2-3 function that Excel use
for compatibility, so you have:
=DATEDIF(C5;D5;"y")&"/"&DATEDIF(C5;D5;"YM")&"/"&DATEDIF(C5;D5;"MD" )
where in C5 is your starting date (2/18/85), while in D5 is your ending date
(8/1/06).
For more informations about the function you can see he
http://office.microsoft.com/en-us/as...609811033.aspx
--
Hope I helped you.
Thanks in advance for your feedback.
Ciao
Franz Verga from Italy