Home |
Search |
Today's Posts |
#1
|
|||
|
|||
How do I create an alert of expiration date in Excel?
I created a spreadsheet to track documents. The last column is for
expiration dates of documents. How can I set up an alert when the expiration date is approaching? |
#2
|
|||
|
|||
Use conditional formatting in the cell. For example, with the date in A12,
something like Formula is =TODAY()+7=$A$12 as the condition. Then choose a pattern. "kachnycz" wrote: I created a spreadsheet to track documents. The last column is for expiration dates of documents. How can I set up an alert when the expiration date is approaching? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Using VLOOKUP with a Date and Time | Excel Discussion (Misc queries) | |||
Date difference | Excel Worksheet Functions | |||
Networkdays | Excel Worksheet Functions | |||
How can I create formula that turns a date into the week # in | Excel Discussion (Misc queries) | |||
Creating a Date Selector in Excel VBA? | Excel Discussion (Misc queries) |