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
|