More date issues

E

Erik

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
 
F

Frank Kabel

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
 
H

Harald Staff

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 said:
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
Click to expand...
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.
 
H

Harald Staff

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.
 
Top