I have a list of dates in column A. These dates are when the next
safety check will (or should) take place. In some cases the safety
checks have been missed and are overdue.

What i would like is some kind of function in column B to state whether
the safety check date is overdue, less than 3 months away, less than 6
months away or more than 6 months away.

I have tried in vain to do this with an IF function. Can someone help?