Certificate tracker: help to distinguish expiry status based on dates (DATEDIF function?)

[tinkerbell02]

Hi,

I am using Microsoft 2010 and I am trying to create a tracker so that I can see when my training certificates are "in date", "out of date" or "due for renewal".

I have a cell C1 with today's date. I have the dates of expiry of certificates in B5:B7.

I would like to generate a formula that outputs:
Due for renewal: if expiry date is within 6 months of todays date.
Out of date: if today is later than expiry date.
In date: if expiry date more than 6 months from today's date.

I have managed =IF(DATEDIF(C1,B5,"m")>=6, "in date", "due for renewal") but I cant manage to get an extra function in to distinguish if it is "out of date".

Help much appreciated.