Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
I want excel to calculate the age of a subject by entering the date of birth
of such subject |
#2
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
See the "Calculating A Person's Age" section of Chip Pearson's website:
http://www.cpearson.com/excel/datedif.htm Does that help? *********** Regards, Ron XL2002, WinXP-Pro "Gdm/kmf" wrote: I want excel to calculate the age of a subject by entering the date of birth of such subject |
#3
![]()
Posted to microsoft.public.excel.newusers
|
|||
|
|||
![]()
Assuming your birthday is in A1
=DATEDIF($A$1,NOW(),"Y")&" Years, "&DATEDIF($A$1,NOW(),"YM")&" Months, "&DATEDIF($A$1,NOW(),"MD")&" Days" "Gdm/kmf" wrote: I want excel to calculate the age of a subject by entering the date of birth of such subject |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
calculate min in col B subject to text in col A | Excel Worksheet Functions | |||
Ranking based on two columns | Excel Worksheet Functions | |||
How can I calculate commissions that are not percentage based? | Excel Discussion (Misc queries) | |||
Subtract a group of cells from a total based on ending date | Excel Discussion (Misc queries) | |||
Calculation based on a condition | Excel Worksheet Functions |