Excel dates are stored as numbers. March 7, 2008 is day 39514. Day 35268 is
July 22, 1996. Please explain what you want with a couple of examples.
Are the policies expired if their dates are less than today's date?
Tyro

"fuchsiahop" wrote in message
...
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!