How do I calculate employment service and display as yy/mm/dd in .

B

Bjair

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.
 
F

Franz Verga

Bjair said:
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.
Click to expand...


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 here:

http://office.microsoft.com/en-us/assistance/HA011609811033.aspx


--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy
 
B

Bjair

Thank you very much .......

Franz Verga said:
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 here:

http://office.microsoft.com/en-us/assistance/HA011609811033.aspx


--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy
Click to expand...
 
Top