Hi,

I posted for someone to help several months back and I received the following formula it worked until Aug1.... AND Now Aug 1 thru December birthdays come up with the CORRECT current age BUT Jan.-July 31 birthdays comes up with One Year Added.......Please I need help altering this formula:

I need a person's current age as of Aug. 1 2006!!! ONLY

Year(Date( 8, 1, Year(Status(CurrentDate)) + (Status(CurrentDate) > Date( 8, 1, Year(Status(CurrentDate)) )) )) - Year(birthdate) -

(Date( 8, 1, Year(Status(CurrentDate)) + (Status(CurrentDate) > Date( 8, 1, Year(Status(CurrentDate)))) ) < Date(Month(birthdate), Day(birthdate), Year(Date( 8, 1, Year(Status(CurrentDate)) + (Status(CurrentDate) > Date( 8, 1, Year(Status(CurrentDate)) ))) )))

If you need to know a person's age at a fixed date, then obviously you should not use Status(CurrentDate) in the calculation. A person's age as of Aug. 1 2006 is given by the birthdate and Aug. 1 2006 alone. Try:

2006 - Year ( BirthDate ) - ( 732524 < Date ( Month ( BirthDate ) , Day ( BirthDate ) , 2006 ))

That worked...Thank you very much. I am formula ignorant.