Please help with date logic problem

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?

Please find for your reveiw and referance this information:

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