t-mac Posted August 15, 2006 Share Posted August 15, 2006 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)) ))) ))) Link to comment Share on other sites More sharing options...
comment Posted August 15, 2006 Share Posted August 15, 2006 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 )) Link to comment Share on other sites More sharing options...
t-mac Posted August 15, 2006 Author Share Posted August 15, 2006 That worked...Thank you very much. I am formula ignorant. Link to comment Share on other sites More sharing options...
Recommended Posts
This topic is 6464 days old. Please don't post here. Open a new topic instead.
Create an account or sign in to comment
You need to be a member in order to leave a comment
Create an account
Sign up for a new account in our community. It's easy!
Register a new accountSign in
Already have an account? Sign in here.
Sign In Now