Good morning!
I have tried a dozen different formulas and I am getting the wrong numbers highlighted every time, so I'm hoping someone can help.
My table looks like this:
NAME / First Aid Expiry Date / Insurance Expiry Date
Joe / 3/9/13 / 8/25/10
My dates are all entered as above and change themselves to the full Month #, 2014 format... so if that's the problem, please let me know. I have attached a sample.SAMPLE.xlsx
Anyways, what I am trying to accomplish is two flags - one for dates that have now expired, and one for dates that will expire in the next month - hopefully then we can remind the staff to renew ahead of time.
I have tried everything I can think of and that I can find on here, but it keeps highlighting random dates, that don't meet the criteria I am looking for.
Bookmarks