Closed
CRIZ - Mar 2, 2012 at 09:57 AM
rizvisa1 Posts 4479 Registration date Thursday January 28, 2010 Status Contributor Last seen May 5, 2022 - Mar 24, 2012 at 06:42 PM
Hello,

I would truly be most greatful for help to calculate a potential cash outlay for my employees depandants schools books using three date variables as reference points.

Using today as a basis for the logic tests: if I have an employee who has more than 5 years of tenure, and their dependant is more than 5 years old but less than 18, or the employee will gain 5 years of tenure between now and the dependants' 18th birthday = how many birthdays will the dependant have between employee reaching tenure and their 18th birthday?

Cell B11 is Employee hire date in MM/DD/YY. Cell C11 is the logical return of DATEIF from Today in Years, Months, Days of the employees tenure. Cell E11 is the Dependants DOB in MM/DD/YY. Cell G11 is the logical return of DATEIF from Today in Years, Months, Days of the dependants' age. Cell H11 is the Dependants date of 18th Birthday in MM/DD/YY format.

Any help in working this problem will be most appreciated and welcome.

I humbly thank you in advance for taking the time to read my problem and helping me find a solution.

Thank you,

Criz
Related: