software

How do you calculate age by a birth date I need years and months... if the
person is not a year old I need to know how many months... if the person is
1yr 2mo I need it to return 1yr 2mo... if the person is only 2mo I need it to
return 2mo.. is there any kind of formula that could work...

Thanks Donna


If you subract the DOb from today() so if the dob was in cell A1

in b1 put today()-a1

Go to format cell ans select the custom number format then type
yy quot;yearsquot; m quot;monthsquot;

regards

Dav--
Dav
------------------------------------------------------------------------
Dav's Profile: www.excelforum.com/member.php...oamp;userid=27107
View this thread: www.excelforum.com/showthread...hreadid=517468Use the following formula in the cell you want the age of person to appear.

=DATEDIF(A5, NOW(), quot;yquot;) amp; quot; yr, quot; amp; DATEDIF(A5, NOW(), quot;ymquot;) amp; quot; moquot;

This formula would be in B5 and the persons DOB would be in A5

Hope this helps.

quot;dallyup2quot; wrote:

gt; How do you calculate age by a birth date I need years and months... if the
gt; person is not a year old I need to know how many months... if the person is
gt; 1yr 2mo I need it to return 1yr 2mo... if the person is only 2mo I need it to
gt; return 2mo.. is there any kind of formula that could work...
gt;
gt; Thanks Donna