Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Converting dates to a number
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 |
#2
|
|||
|
|||
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 he http://www.vbaexpress.com/kb/getarticle.php?kb_id=323 HTH, and regards, Zack Barresse "Kathy" wrote in message ... 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 |
#3
|
|||
|
|||
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" 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 |
#4
|
|||
|
|||
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" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stop numbers converting to dates. | Excel Worksheet Functions | |||
Counting the number cells between two dates | Excel Discussion (Misc queries) | |||
Count the number of dates in a range that are earlier than today. | Excel Worksheet Functions | |||
Where is DateDiff function in Excel 2002 ? | Excel Worksheet Functions | |||
Total number of each month in a column of dates | Excel Worksheet Functions |