Hi Mike,

Yes on both counts.

To find out more about how Excel handles dates just
type date into the answer wizard in the help file.

Also in the help file you can find out about
conditional formatting.

If you are having trouble sorting that out then post
an example of your data and what you want it to do
and someone here will show you the correct way to
make those functions work for you.

HTH
Martin


"mike" wrote in message
...
I am currently using excel 2003, and i understand that excel is able to
calculate dates by using a coding system. is it possible to set up a sort
of
active document, where by inputted dates that have expired would be
flagged
up in some way? for example; change colour of either the text or the cell
itself?
(if this makes no sense just give us a shout and i'll try and explain
again
haha!)
thanks,
Mike.