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.

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

http://office.microsoft.com/en-us/as...609811033.aspx


--
Hope I helped you.

Thanks in advance for your feedback.

Ciao

Franz Verga from Italy

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 here:
>
> http://office.microsoft.com/en-us/as...609811033.aspx
>
>
> --
> Hope I helped you.
>
> Thanks in advance for your feedback.
>
> Ciao
>
> Franz Verga from Italy
>
>
>