Conditional formula's in excel-calculating with dates / age and affiliation date calculus

Good afternoon,

I would need a hand on the following 2 things I'm trying to do in Excel 2010.

1. If a date falls between two others return TRUE
e.g. Date in Service < Date of 25th Birthday < Date of 6 Months in Service
Date in service in B6
Date of 25th Birthday in B12
Date of 6 Months in Service in B11
My dates are formated as dd/mm/yyyy
I wrote the formula in B19 =B6<B12<B11 which is not doing the trick.
Any suggestions?

2. Employees can subscribe to an insurance depending on their age and time in service.
I'm stuck on: Affiliation from the 1st of the month following or coinciding with the completion of 6 months of service
or if age 25 is reached before the 6 months of in service, affiliation from the 1st of the month following the 25th Birthday.

For the Affiliation from the 1st of the month following or coinciding with the completion of 6 months of service I wrote this formula in cell B27 =DATE(YEAR(B6);MONTH(B6)+1; 1) with B6 being Date in service

How do I combine it with the second condition: if age 25 (B12) is reached before the 6 months of in service (B11), affiliation from the 1st of the month following the 25th Birthday

I hope my questions become clearer when you open the attached spreadsheet with my current calculations.

Thanks in advance for your help!

And here is the promised attachment.

Hi,

Thank you so much. It did the tricks and now I know how to compile future formula's