Finding 6 Months (or More) Apart Date

Which cells are you comparing. Suggest for the data shown, you mock up a solution so we understand exactly what you need.

Hi

The formula or Conditional formatting will need to look at all the dates in that row and then look to see which dates are 6 months apart or more than 6 months apart from the oldest date in that row and list them as show below or even highlight the dates, one colour for 6 months apart and another for more than 6 months

Not to sure which will work better out of a formula or conditional formatting

Im thinking with conditional formatting i can used or create a Colour Key Code table

Hope this helps

Solution Capture.JPG

Do the mock-up in the workbook, not a screenshot, please.

Where there is no previous recall date, how should we work out whether it's 6 months or 6 months plus - what's the logic?

Please try the following conditional formatting formulas.
For blue: =AND(L3<>"",DATEDIF(MIN($L3:$X3),L3,"m")>6)
For green: =AND(L3<>"",DATEDIF(MIN($L3:$X3),L3,"m")=6)
Note that formulas in columns AA:AB are there for illustrative purposes and are not needed for conditional formatting.
Let us know if you have any questions.