Hi!

You have 2 options:

1. use VBA code
2. hardcode the date

I can't help with 1.

For 2, you can just enter the date in one cell and link the other date cells
to that one cell.

CTRL ; (semicolon) enters the date.

Biff

"BW" wrote in message
...
Hello,

I've created excel worksheet that auto-populates certain cells with
today's
date to facilate filling out a purchase order worksheet.

But problem is once i save the worksheet, and open it at some other date
the Today() function gets executed again a re-populates those cells with
today's date, instead of keeping the original date. HOw can i prevent
this
from happening so that when the worksheet is opened at some future day,
those
cells will retain the original date.