It must be a formula (=TODAY()).

You need to input the dates (Ctrl-:), or use VBA to set them.

What does the spreadsheet do?

--
HTH

Bob Phillips

"Jackie" wrote in message
...
When I open a file, the dates keep changing to the current date. How do I
stop this?