View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Laura N
 
Posts: n/a
Default Function to find expired information

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!