Help need with formula

[smith.james0]

I need to work out how many years and months someone been alive. Can anyone help?

[olasa]

This is one option:

A1: birthdate
B1: =DATEDIF(A1,TODAY(),"Y")&" years & "&MOD(DATEDIF(A1,TODAY(),"M"),12)&" months"

Ola Sandström

[Domenic]

Also...

=DATEDIF(A1,TODAY(),"Y")&" Years, "&DATEDIF(A1,TODAY(),"YM")&" Months"

Hope this helps!

[olasa]

Much better...

Hi

Have a look at DATEDIF. Here is some info on how it works:
http://www.cpearson.com/excel/datedif.htm

Andy.

"smith.james0" <[email protected]>
wrote in message
news:[email protected]...
>
> I need to work out how many years and months someone been alive. Can
> anyone help?
>
>
> --
> smith.james0
> ------------------------------------------------------------------------
> smith.james0's Profile:
> http://www.excelforum.com/member.php...o&userid=16230
> View this thread: http://www.excelforum.com/showthread...hreadid=374933
>

[Ragdyer]

Try the Datedif function.

It's undocumented except in XL2k.

BUT, you can find it explained at Chip Pearson's web site at:

http://www.cpearson.com/excel/datedif.htm
--
HTH,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"smith.james0" <[email protected]>
wrote in message
news:[email protected]...
>
> I need to work out how many years and months someone been alive. Can
> anyone help?
>
>
> --
> smith.james0
> ------------------------------------------------------------------------
> smith.james0's Profile:
http://www.excelforum.com/member.php...o&userid=16230
> View this thread: http://www.excelforum.com/showthread...hreadid=374933
>

[smith.james0]

Thanks a lot that works great