View Single Post
  #2   Report Post  
David Billigmeier
 
Posts: n/a
Default How do I set up a notification for expired items in Excel?

If your dates start in A1, put this in B1 and drag down:

=IF(A1<TODAY(),"Expired Contract","")


--
Regards,
Dave


"Striving for efficiency" wrote:

Is there a function that I can set up to notify me when a contract expires?
I use an Excel spreadsheet to track contracts and insurance certificates and
dates and so on. I was thinking there should be a way to produce a
notification when a certain cell with a date entered expires - make sense?

Thank you