From: Mark on 26 Mar 2010 18:28 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! From: Roger Govier on 26 Mar 2010 18:48 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! From: FSt1 on 26 Mar 2010 19:03 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!  |  Pages: 1 Prev: sorting in Excel 2007 problemNext: Updating Next Consecutive Cell in Range