Date subtraction problem

[mickey cain]

This should be so simple but I can't get my head around it.

Birth date

28/03/1967

Todays date

21/08/2003

How many days/months/years have I been alive.

 

[Chip Pearson]

Mickey,

You need the DATEDIF function. See
www.cpearson.com/excel/datedif.htm for details. To compute an age
where the birthday is in cell A1, use

=DATEDIF(A1,NOW(),"y") & " years, " & DATEDIF(A1,NOW(),"ym") & "
months, " & DATEDIF(A1,NOW(),"md") & " days"


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com (e-mail address removed)