Function to find expired information

[Laura N]

I am trying to create a function which will let me know when a particular
date has passed or expired. For example, a person has insurance which
expires on 4/30/06 - I want something that will let me know on 4/31/06 that
that person's insurance is expired. Maybe also create a macro that will
automatically filter all the expired's. Is there anyway to do this? I
tried VLOOKUP, I tried an IF function, but I'm just not sure exactly how to
write this.

Thanks a million!

 

[JethroUK©]

take a look at conditional formatting:

Select the column with the dates

Format>Conditional Formatting

Cell Value Is Greater than =NOW()
Format Colour = Red

OK

 

[JethroUK©]

p.s. - maybe you should also have 28 days notice:

Cell Value Is Greater than =NOW()-28

Format Colour = Amber