Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I calculate ages in excel using date of birth & another dat
Using excel 2003 I wish to insert a column with a date of birth and another
column with another date eg 1/1/2005. I would then like to calulate the age of each person in my list as at 1 Jan 05. |
#2
|
|||
|
|||
How do I calculate ages in excel using date of birth & another dat
http://www.cpearson.com/excel/datedif.htm
-- Regards, Peo Sjoblom (No private emails please) "Paniac" wrote in message ... Using excel 2003 I wish to insert a column with a date of birth and another column with another date eg 1/1/2005. I would then like to calulate the age of each person in my list as at 1 Jan 05. |
#3
|
|||
|
|||
How do I calculate ages in excel using date of birth & another dat
in excel 2000 there is a function <datedif see help
"Paniac" wrote in message ... Using excel 2003 I wish to insert a column with a date of birth and another column with another date eg 1/1/2005. I would then like to calulate the age of each person in my list as at 1 Jan 05. |
#4
|
|||
|
|||
How do I calculate ages in excel using date of birth & another dat
On Mon, 17 Oct 2005 19:36:02 -0700, Paniac
wrote: Using excel 2003 I wish to insert a column with a date of birth and another column with another date eg 1/1/2005. I would then like to calulate the age of each person in my list as at 1 Jan 05. If dob is in A1, and the other date in B1, then: =DATEDIF(A1,B1,"Y") --ron |
#5
|
|||
|
|||
How do I calculate ages in excel using date of birth & another dat
Excel 2000 is the only version that has a help section about datedif
-- Regards, Peo Sjoblom (No private emails please) "R.VENKATARAMAN" wrote in message ... in excel 2000 there is a function <datedif see help "Paniac" wrote in message ... Using excel 2003 I wish to insert a column with a date of birth and another column with another date eg 1/1/2005. I would then like to calulate the age of each person in my list as at 1 Jan 05. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
date format in excel not in line with control panel regional setti | Excel Discussion (Misc queries) | |||
Excel date field link to Word | Excel Discussion (Misc queries) | |||
how to calculate a date .. say 34 days from today | Excel Discussion (Misc queries) | |||
Excel enters date as a text format | Excel Discussion (Misc queries) | |||
Creating a Date Selector in Excel VBA? | Excel Discussion (Misc queries) |