Jump to content

Calculation Adjustment-HELP


This topic is 5582 days old. Please don't post here. Open a new topic instead.

Recommended Posts

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

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

This topic is 5582 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 account

Sign in

Already have an account? Sign in here.

Sign In Now
 Share

×
×
  • Create New...

Important Information

By using this site, you agree to our Terms of Use.