Date to years

[Savage]

Is there anyway of converting a date to the amount of years. I have
employees years started posted and I want to convert to years worked with the
company.

Thanks

Kevin

[Chip Pearson]

Use the DATEDIF command.

=DATEDIF(start_date, TODAY(),"y")

See www.cpearson.com/excel/datedif.htm for more info about
DATEDIF.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com



"Savage" <[email protected]> wrote in message
news:[email protected]...
> Is there anyway of converting a date to the amount of years. I
> have
> employees years started posted and I want to convert to years
> worked with the
> company.
>
> Thanks
>
> Kevin

[pinmaster]

Hi, try this:

=DATEDIF(A1,TODAY(),"y") # years

you can also use:

"m" - months
"d" - days
"ym" - year months
"yd" - year days

HTH
JG

Hi

If the date is a recognised Excel date, you can simply deduct the date from
today's date and format the result as yy.

Hope this helps.
Andy.

"Savage" <[email protected]> wrote in message
news:[email protected]...
> Is there anyway of converting a date to the amount of years. I have
> employees years started posted and I want to convert to years worked with
> the
> company.
>
> Thanks
>
> Kevin

[Peo Sjoblom]

If you only have the starting years and want a rough estimate (calendar
years) you can use

=YEAR(TODAY())-A1

where A1 holds the start year

--
Regards,

Peo Sjoblom

(No private emails please)


"Savage" <[email protected]> wrote in message
news:[email protected]...
> Is there anyway of converting a date to the amount of years. I have
> employees years started posted and I want to convert to years worked with
> the
> company.
>
> Thanks
>
> Kevin

[Savage]

thanks, works great

"pinmaster" wrote:

>
> Hi, try this:
>
> =DATEDIF(A1,TODAY(),"y") # years
>
> you can also use:
>
> "m" - months
> "d" - days
> "ym" - year months
> "yd" - year days
>
> HTH
> JG
>
>
> --
> pinmaster
> ------------------------------------------------------------------------
> pinmaster's Profile: http://www.excelforum.com/member.php...fo&userid=6261
> View this thread: http://www.excelforum.com/showthread...hreadid=494468
>
>