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

 

[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

 

[Guest]

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

 

[smith.james0]

Thanks a lot that works great