Here's a formula that lets you know when a specific date is approaching:

=IF((NOW()+5)<DATE(2005,6,14),"OK","Approaching a critical date")

When you get to within the critical time period, the value in the cell
changes.

--
Andy Wiggins FCCA
www.BygSoftware.com
Excel, Access and VBA Consultancy
-

"AR Voice" <AR wrote in message
...
I would like to know if there is a way to set up an expiry date in an
excel
worksheet that lets you know when it is approaching a specific date.
Currently using Excel 2002