tinkerbell02
New Member
- Joined
- Nov 5, 2015
- Messages
- 1
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.
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.
