More date issues

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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