Excell DOB convert to age

[MIKERYAN]

First skills may be overstated Tech/user may be my speed.
In Excell is there a (cell) formula to convert date 00/00/000 to numerical age 00 years old

 

[repete]

Hi Mikeryan

try this

cell A1 enter a birth date
cell B1 =today()
cell C1 +B1 - A1 (number format to give number of days)
cell D1 +C1/365 gives years

not precise, as there are leap years involved, but I imagine this may help with your query.

Regards


Pete Bloomfield
Down Under

 

[MIKERYAN]

Thanks repete. I also have found formula Rounddown(Now()-Dob)/365.25 will give whole numbers

 

[repete]

yep, you could also use round() and roundup() as required. also check out ceiling() and floor() to see how these work.

Regards Pete Bloomfield
Down Under

 

[DaveStL]

You could also use today() instead of now(). Today() does not include the time, now() does.

Here are a couple of pages that can be useful when working with dates:

http://support.microsoft.com/search/preview.aspx?scid=kb;en-us;Q214094

and:

http://support.microsoft.com/search/preview.aspx?scid=kb;en-us;Q245104