Hi Erik
enter the first date in a cell (lets say in A1) and enter the following
formula in B1
=A1+1
format this as date and copy to the left

--
Regards
Frank Kabel
Frankfurt, Germany

Erik wrote:
I should probably gather a bunch of my problems and ask about them
all at once.

I have a row of cells that are column headers for the days of the
week. Before each day(text) is a blank cell for the date(03/01/04).
I would like to be able to enter the date in the first blank date
cell and have the other 6 fill automatically. The closest built in
formula I could find was Workday(), but that only accounts for Mon -
Fri. I need to figure all seven days of the week.

Erik