Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I calculate the number of years between 2 dates
Hi
I need to calculate the age of a person so in one cell i have the persons dob and in another cell i have a static date ie, 25/12/06 (i'm british). how do i calculate how old a person born 30/04/73 whould have been on christmas day this year. Thank you. |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I calculate the number of years between 2 dates
=DATEDIF(dob,christmas,"Y")
-- --- HTH Bob (change the xxxx to gmail if mailing direct) "Leisl" wrote in message ... Hi I need to calculate the age of a person so in one cell i have the persons dob and in another cell i have a static date ie, 25/12/06 (i'm british). how do i calculate how old a person born 30/04/73 whould have been on christmas day this year. Thank you. |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I calculate the number of years between 2 dates
If your dob is in A1 and static date in B1
=DATEDIF(A1,B1,"y") see here for information on DATEDIF function http://www.cpearson.com/excel/datedif.htm "Leisl" wrote: Hi I need to calculate the age of a person so in one cell i have the persons dob and in another cell i have a static date ie, 25/12/06 (i'm british). how do i calculate how old a person born 30/04/73 whould have been on christmas day this year. Thank you. |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I calculate the number of years between 2 dates
Thank you to both of you. Perfect.
"daddylonglegs" wrote: If your dob is in A1 and static date in B1 =DATEDIF(A1,B1,"y") see here for information on DATEDIF function http://www.cpearson.com/excel/datedif.htm "Leisl" wrote: Hi I need to calculate the age of a person so in one cell i have the persons dob and in another cell i have a static date ie, 25/12/06 (i'm british). how do i calculate how old a person born 30/04/73 whould have been on christmas day this year. Thank you. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I subtract dates to get a number in years or years & month | Excel Discussion (Misc queries) | |||
Calculate number of months between dates | Excel Worksheet Functions | |||
Calculate number of years and months employed using hire date and. | Excel Worksheet Functions | |||
Function to calculate the number of years, months and days between | Excel Worksheet Functions | |||
How do you calculate the nth root of a number in Excel 2003? | Excel Worksheet Functions |