Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Date of expiry - warning?
Hi,
could anyone help in how to make a function that warns when a cell contains a date that has expired due to a predefined timespan? Basically what I have is a column with dates and I want to create a function in a second column that warn whenever one of the dates are more then 3 years old in relation to the current date. Any suggestions? All the best Jonas |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How do I create a schedule from a list of dates ? | Charts and Charting in Excel | |||
Another Date issue. | Excel Worksheet Functions | |||
Cond Format: Expiry Date Alert | Excel Discussion (Misc queries) | |||
Date Math Problem | Excel Worksheet Functions | |||
Need help troubleshooting an array formula XLXP on Win2K | Excel Worksheet Functions |