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
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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks