Does the OP need the time (NOW())? Perhaps. Some policies expire on a given
date at a given time. Or perhaps the OP needs only the date (TODAY())

Tyro

"Sean Timmons" wrote in message
...
sounds like all you need is a conditional format, cell value is/less
than/
now() turn the cell red or whatever... If you are basing it on the day,
and
don't want it to change color until the day after, change the now() to
roundup(now())
This will check against tomorrow's date.

"fuchsiahop" wrote:

I would like to set an alarm/alert that would let me know when a policy
date
has expired. It would have to scan/check all the dates in the expiration
column. The dates are shown as 3/7/2008 not 35268. I am running Office
2003 sp2.
Any help would be greatly appreciated!