Help need with formula
 

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

This is one option:

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

Ola Sandström


--
olasa
------------------------------------------------------------------------
olasa's Profile: http://www.excelforum.com/member.php...o&userid=17760
View this thread: http://www.excelforum.com/showthread...hreadid=374933

Also...

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

Hope this helps!


--
Domenic
------------------------------------------------------------------------
Domenic's Profile: http://www.excelforum.com/member.php...o&userid=10785
View this thread: http://www.excelforum.com/showthread...hreadid=374933

Much better...


--
olasa
------------------------------------------------------------------------
olasa's Profile: http://www.excelforum.com/member.php...o&userid=17760
View this thread: http://www.excelforum.com/showthread...hreadid=374933

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"
wrote in message
news:smith.james0.1ptaab_1117400703.8379@excelforu m-nospam.com...

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

Hi

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

Andy.

"smith.james0"
wrote in message
news:smith.james0.1ptaab_1117400703.8379@excelforu m-nospam.com...

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

Thanks a lot that works great :)


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