If you have this formula in a cell:

=TODAY()

then everytime you open the file it will show the current date in that
cell automatically.

So, you could derive your dates from this.

However, it would mean that the dates would change every (new) day
that you opened the file.

It might be better to put the start date in a cell (eg put 01/01/2009
in A1), then in A2 you can have this formula:

=A1+1

which should show 2nd January, and you can copy the simple formula
down to row 31 to get all the dates in January.

Then for a new month, all you need is to change the starting date in
A1 and the other cells will change automatically.

Hope this helps.

Pete

On Jan 8, 2:24*pm, kayak99 wrote:
Hope I explain this correctly. I need to make (two sided) tabbed spreadsheets
available for individuals to use for each day of the year.

I'm okay building the speadsheets themselves but I want to date each one,
front and back for the current date without having to type that in daily.

Isn't there a way I could do one or two each month, then drag the tabs out
to, say 31, for January, repeat for Februuary, etc?

Or, is there a way to have one spreadsheet and each time it's opened it has
the current (computer) date on it?

I'm somewhat formula deficient so please be real specific

Thanks