How do I create formula to calc difference in dates?

[C]

Hi I'm hoping someone can point me in the right direction. I tried the
formula listed here and a few others and I can seem to get the right result.
I need a column to calculate age. I have todays date in G17 and the DOB in G3.

 

[Gord Dibben]

=DATEDIF(G3,G17,"y") & "years," & DATEDIF(G3,G17,"ym") & "months,"&
DATEDIF(G3,G17,"md") & "days,"

For more help on the undocumented DATEDIF function see Chip Pearson's site.

http://www.cpearson.com/excel/datedif.aspx


Gord Dibben MS Excel MVP