How do I create formula to calc difference in dates?

C · May 12, 2010

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 · May 12, 2010

=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