How do I create formula to calc difference in dates?

[Bob I]

Subtracting one date from another is always going to give that result.
It's the same as subtracting one number from another. If you want
inclusive, you will have to add one back or subtract the day before the
start day.

 

[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