I need a formula that does the following:

Calculates how old I am when a birth date is entered. The formula needs to
use the calendar days not a fixed number of days per month. The second part
is if the person is more than half way through the year the age needs to
increase by one. For example my birthday is april 14 1973. That make me 36
years old. Because I am more than half way through the year the formula
needs to tell me that I am 37. Any help would be appreciated please remember
it must be calendar days not a fixed number of days per month. Thanks!

Hi Mark

With birthdate in A1
=ROUNDUP(DATEDIF(A1,TODAY(),"m")/12,0)
--
Regards
Roger Govier

Mark wrote:
I need a formula that does the following:

Calculates how old I am when a birth date is entered. The formula needs to
use the calendar days not a fixed number of days per month. The second part
is if the person is more than half way through the year the age needs to
increase by one. For example my birthday is april 14 1973. That make me 36
years old. Because I am more than half way through the year the formula
needs to tell me that I am 37. Any help would be appreciated please remember
it must be calendar days not a fixed number of days per month. Thanks!

hi
try this......
date in A1, formula in B1....
=IF(DATEDIF(A1,TODAY(),"ym")=6,DATEDIF(A1,TODAY() ,"y")+1,DATEDIF(A1,TODAY(),"y"))

careful. formula wraped.

Regards
FSt1


"Mark" wrote:

I need a formula that does the following:

Calculates how old I am when a birth date is entered. The formula needs to
use the calendar days not a fixed number of days per month. The second part
is if the person is more than half way through the year the age needs to
increase by one. For example my birthday is april 14 1973. That make me 36
years old. Because I am more than half way through the year the formula
needs to tell me that I am 37. Any help would be appreciated please remember
it must be calendar days not a fixed number of days per month. Thanks!