What formula could I use to convert a date of birth into an age?, e.g.,
06/25/71, 33.
Yes, I know I can just subtract but is there a formula that can do it?
Marguerite
What formula could I use to convert a date of birth into an age?, e.g.,
06/25/71, 33.
Yes, I know I can just subtract but is there a formula that can do it?
Marguerite
A very rough way of doing so, if you don't need to count leap years ...
=Int((Today()-A1)/365)&" years old"
Where A1 is the cell which houses your date. Note this MUST be an Excel
recognized date. To check if it's an Excel recognized date, look here:
http://www.vbaexpress.com/kb/getarticle.php?kb_id=323
HTH, and regards,
Zack Barresse
"Kathy" <[email protected]> wrote in message
news:[email protected]...
> What formula could I use to convert a date of birth into an age?, e.g.,
> 06/25/71, 33.
>
> Yes, I know I can just subtract but is there a formula that can do it?
>
> Marguerite
Marguerite
With early date in A1 and later date or =TODAY() Function in A2
=DATEDIF(A1,A2,"y") & "years," in A3
To get finer resolution enter in A3
=DATEDIF(A1,A2,"y") & "years," & DATEDIF(A1,A2,"ym") & "months,"&
DATEDIF(A1,A2,"md") & "days,"
Note: above is all one line.
Gord Dibben Excel MVP
On Tue, 26 Apr 2005 11:14:11 -0700, "Kathy" <[email protected]>
wrote:
>What formula could I use to convert a date of birth into an age?, e.g.,
>06/25/71, 33.
>
>Yes, I know I can just subtract but is there a formula that can do it?
>
>Marguerite
Here's a link to DATEDIF that might help you.
http://www.bygsoftware.com/Excel/functions/datedif.htm
--
Regards
-
Andy Wiggins FCCA
www.BygSoftware.com
Excel, Access and VBA Consultancy
"Kathy" <[email protected]> wrote in message
news:[email protected]...
> What formula could I use to convert a date of birth into an age?, e.g.,
> 06/25/71, 33.
>
> Yes, I know I can just subtract but is there a formula that can do it?
>
> Marguerite
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks