How do I set up a notification for expired items in Excel?

G

Guest

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
 
G

Guest

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

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

Guest

I never was good with IF statements...can you explain this? I get confussed
with all of the punctuations: () "," thank you
 
G

Guest

Check the help menu for an in depth explanation of it, basically:

=IF(condition_you_want_to_test , value_if_true , value_if_false)
 
G

Guest

I tried to take my arguement further and an error window popped up explaining
too many arguments. I got my cell to come back with "Expired Contract", what
do I add to this formula to come back blank if it is false or if there is no
data?

Thank you!!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

How do I set up excel to let me know when a date has expired? 1
EXPIRED or DATE 3
How do I create a popup notification in excel ? 8
Excel spreadsheet change colour of cell back ground depending on d 1
Excel alert/Notification 1
#N/A help please 2
How do I prevent duplication information, such as SSNs in cells. 1
Designing a Database 4

Top