I am entering Date of birth in a cell and i would like to calculate age in
another cell. how to do about it ?
I am entering Date of birth in a cell and i would like to calculate age in
another cell. how to do about it ?
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" <[email protected]> wrote in message
news:[email protected]...
> I am entering Date of birth in a cell and i would like to calculate age in
> another cell. how to do about it ?
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 ?
=DATEDIF(A1,B1,"Y")Originally Posted by DHANRAJ
Syntax
DATEDIF(start_date,end_date,unit)
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 ?
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 ?
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks