Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
what is the formula for getting current age from Date of Birth
I'm setting up a spreadsheet which contains peoples names and Dates of Birth.
I need to had to have a formula that will calculate and display indiviuals current AGE, from D.O.B. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
what is the formula for getting current age from Date of Birth
Hi,
If Birth date is in cell A1 and today() in cell B1 : =DATEDIF(A1,B1,"Y") & " Years, " & DATEDIF(A1,B1,"YM") & " Months, " & DATEDIF(A1,B1,"MD") & " Days" HTH Cheers Carim |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
what is the formula for getting current age from Date of Birth
If D.O.B is in A1 then:
=DATEDIF(A1,TODAY(),"y") & " years, " & DATEDIF(A1,TODAY(),"ym") & " months, " & DATEDIF(A1,TODAY(),"md") & " days" will give age. for example if A1 contains: 1/15/1985 the formula will return: 21 years, 8 months, 15 days -- Gary''s Student "smudge" wrote: I'm setting up a spreadsheet which contains peoples names and Dates of Birth. I need to had to have a formula that will calculate and display indiviuals current AGE, from D.O.B. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
what is the formula for getting current age from Date of Birth
in a cell say A1 type =today().This will always shows todays date
in another column you will have all the birthaday,say E:E in say G1 you have the formula $A$1 - E1 In g1 rightclick and choose format cell go to custom format and using a date format shown to start with type say y "yr" m "mnths"Your answers will show 25 yr 3 mnths or similar -- paul remove nospam for email addy! "smudge" wrote: I'm setting up a spreadsheet which contains peoples names and Dates of Birth. I need to had to have a formula that will calculate and display indiviuals current AGE, from D.O.B. |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
what is the formula for getting current age from Date of Birth
Thanks, this was very helpful. Am now trying to sort the newly calculated
ages in ascending order, and get #REF. Can you help? "Gary''s Student" wrote: If D.O.B is in A1 then: =DATEDIF(A1,TODAY(),"y") & " years, " & DATEDIF(A1,TODAY(),"ym") & " months, " & DATEDIF(A1,TODAY(),"md") & " days" will give age. for example if A1 contains: 1/15/1985 the formula will return: 21 years, 8 months, 15 days -- Gary''s Student "smudge" wrote: I'm setting up a spreadsheet which contains peoples names and Dates of Birth. I need to had to have a formula that will calculate and display indiviuals current AGE, from D.O.B. |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
what is the formula for getting current age from Date of Birth
You need to keep your columns together. You probably need to highlight both
columns before you sort. Regards, Fred "Quincy" wrote in message ... Thanks, this was very helpful. Am now trying to sort the newly calculated ages in ascending order, and get #REF. Can you help? "Gary''s Student" wrote: If D.O.B is in A1 then: =DATEDIF(A1,TODAY(),"y") & " years, " & DATEDIF(A1,TODAY(),"ym") & " months, " & DATEDIF(A1,TODAY(),"md") & " days" will give age. for example if A1 contains: 1/15/1985 the formula will return: 21 years, 8 months, 15 days -- Gary''s Student "smudge" wrote: I'm setting up a spreadsheet which contains peoples names and Dates of Birth. I need to had to have a formula that will calculate and display indiviuals current AGE, from D.O.B. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Formula for determining if two date columns fall within specific date range | Excel Worksheet Functions | |||
Formula for determining if two date columns fall within specific date range | Excel Discussion (Misc queries) | |||
including current date in formula | Excel Worksheet Functions | |||
formula for filtering and a defaulting date | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions |