How to substract date.

hi,

i have to substract two dates frm two diff cells. Actually i have to find a persons age in year month and day.

So any body can help with the formula.

This formula from Chip Pearson website might help

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



http://www.cpearson.com/excel/datedif.htm#Age

VBA Noob