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

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.

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

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

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

Thank you very much .......

"Franz Verga" wrote:

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