How do I set up alarms for expired dates in an excel spreadsheet?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In a spreadsheet containing dates, i'd like to set up some sort of
flag/alarm, that will pop up when the date is about to expire?
 
Hi
I would use conditional formating for this and a formula within this
dialog such as
=A1<TODAY()
 
To test for about to expire, use something like

=A1-5<TODAY()

for 5 days, or whatever number you want
 
You must log in or register to reply here.

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

alarm on a date cell? 2
Expiration dates 7
Excel Formula - Count Dates from another Sheet 8
How to set up alarm for cell has entry as date when it expires? 1
Flagging dates with conditional formatting 2
find expired dates =IF((E11-TODAY()<0), "EXPIRED", "OK") 1
Macros Automatically Sort 5
can alarm be coded into a cell "x" hours before date's reached ? 1

Back
Top