| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
calculating ages
What is the best way to calculate the age of a person in number of years,
months, days, given their birth date? Getting the difference between dates in number of days, and dividing by 365 may not be correct to the exact day given leap years. Is there another way? |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
calculating ages
If birth date is in A1 and TODAY() is in B1, then B1-A1 will return the
number of days. Make sure that the cell in which B1-A1 is is formatted as numbers. Dave -- Brevity is the soul of wit. "pama" wrote: What is the best way to calculate the age of a person in number of years, months, days, given their birth date? Getting the difference between dates in number of days, and dividing by 365 may not be correct to the exact day given leap years. Is there another way? |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
calculating ages
For info on the undocumented DATEDIFF function see Chip's site
www.cpearson.com best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "pama" wrote in message ... What is the best way to calculate the age of a person in number of years, months, days, given their birth date? Getting the difference between dates in number of days, and dividing by 365 may not be correct to the exact day given leap years. Is there another way? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
calculating ages
That's what I was looking for, thank you.
"Bernard Liengme" wrote: For info on the undocumented DATEDIFF function see Chip's site www.cpearson.com best wishes -- Bernard V Liengme www.stfx.ca/people/bliengme remove caps from email "pama" wrote in message ... What is the best way to calculate the age of a person in number of years, months, days, given their birth date? Getting the difference between dates in number of days, and dividing by 365 may not be correct to the exact day given leap years. Is there another way? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Linked Check Boxes | Excel Discussion (Misc queries) | |||
| Taking age group Ie ages 20-29 and picking out net sales for group | Excel Worksheet Functions | |||
| calculating excel spreadsheet files for pensions and life insurance (including age calculation sheets) | Excel Worksheet Functions | |||
| AGE CALCULATING EXCEL SPREADSHEETS AND OTHERS! | Excel Discussion (Misc queries) | |||
| Calculating Ages from Birthdates | Excel Discussion (Misc queries) | |||
Linear Mode
