Microsoft Excel "Quick Tips"

Calculate A Person's Age

Here is an easy way to calculate someone’s age using Excel. In cell A1 enter someones date of birth and in another cell enter this formula (copy and paste it right from this page).

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

This will return a string like: 33 years, 9 months, 18 days

You could also use this technique in many other situations where you need to calculate the time between today and some any other date.

Why not print (CTRL+P) this tip and
share it with your friends and associates?

Get more time-saving tips just like this one delivered to you by email every week in my FREE newsletter "Spreadsheet Tips From An Excel Addict".
Subscribe at the and you could win a really cool t-shirt.
You'll be amazed how much time you'll save just by learning a few of these tips.
Copyright © 2002 All Rights Reserved by FJH Marketing

Close this window