Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
To Calculate age in a cell
I am entering Date of birth in a cell and i would like to calculate age in
another cell. how to do about it ? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
To Calculate age in a cell
dhanraj, have a look here,
http://www.cpearson.com/excel/datedif.htm# -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "DHANRAJ" wrote in message ... I am entering Date of birth in a cell and i would like to calculate age in another cell. how to do about it ? |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
To Calculate age in a cell
If the DOB is in B2, =DATEDIF(B2,TODAY(),"y") will give you the age.
"DHANRAJ" wrote: I am entering Date of birth in a cell and i would like to calculate age in another cell. how to do about it ? |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
To Calculate age in a cell
DHANRAJ Wrote: I am entering Date of birth in a cell and i would like to calculate age in another cell. how to do about it ? =DATEDIF(A1,B1,"Y") Syntax DATEDIF(start_date,end_date,unit) -- davesexcel ------------------------------------------------------------------------ davesexcel's Profile: http://www.excelforum.com/member.php...o&userid=31708 View this thread: http://www.excelforum.com/showthread...hreadid=529972 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
To Calculate age in a cell
My DOB is in dd:mm:yy format and when I give the formula I get get a return
value #VALUE!. "bpeltzer" wrote: If the DOB is in B2, =DATEDIF(B2,TODAY(),"y") will give you the age. "DHANRAJ" wrote: I am entering Date of birth in a cell and i would like to calculate age in another cell. how to do about it ? |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
To Calculate age in a cell
I'm not sure I understand. If you've entered a date, the datedif function
should work. If you've entered TEXT with the :'s etc, you first need to convert to true Excel dates: =DATE(RIGHT(B2,2),MID(B2,4,2),LEFT(B2,2)) would convert the text string to a date (assuming that you've ALWAYS got two chars each for mm, dd and yy). So =datedif(DATE(RIGHT(B2,2),MID(B2,4,2),LEFT(B2,2)), today(),"y") would conver the text and then calculate the years that have elapsed since then. "DHANRAJ" wrote: My DOB is in dd:mm:yy format and when I give the formula I get get a return value #VALUE!. "bpeltzer" wrote: If the DOB is in B2, =DATEDIF(B2,TODAY(),"y") will give you the age. "DHANRAJ" wrote: I am entering Date of birth in a cell and i would like to calculate age in another cell. how to do about it ? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Adding a row to worksheet does not update cell references in another. | Excel Worksheet Functions | |||
Urgent date/scheduling calc needed | Excel Worksheet Functions | |||
formula to calculate future date from date in cell plus days | Excel Worksheet Functions | |||
how do I calculate hours using one cell only | Excel Worksheet Functions | |||
X IN A CELL TO CALCULATE A FORMULA | Excel Worksheet Functions |