More date issues
 

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

More date issues
 

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

More date issues
 

Hi Erik

Enter a date in -say- A1. In cell A2 put the formula
=A1+1
and in A3 the formula
=A2+1
....and so on. 1 is a day in Excel.

--
HTH. Best wishes Harald
Followup to newsgroup only please.

"Erik" wrote in message
...
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

More date issues
 

You're welcome Erik.
Don't be ashamed. Date and time in Excel, and other MS apps, is very simple,
but not intuitive and not obvious. I think it's the topic that generates
most newsgroup questions.

--
HTH. Best wishes Harald
Followup to newsgroup only please

"Erik" skrev i melding
...
That was so easy I'm ashamed of myself for not thinking of it. Once
again, thank you.
Erik