Date Calculation

  • Thread starter Thread starter Donald
  • Start date Start date
D

Donald

I know you have probably answered this question before but here it is again.

I have a document that I am trying to make easier to fill in (weekly we have
to make upwards of 182 different documents).

I have seven fields that I need to put the dates into starting with monday
and ending on sunday. Is it possible to enter monday's date in the first
field and Excel enter the next six days including it the last few days of
the month and it makes that adjustment.

Basically it looks like this:

Monday Tuesday Wednesday Thursday
Friday Saturday Sunday
(A,8) (C,8) (E,8)
(G,8) (I,8) (K,8) (M,8)
 
If you enter a date in a cell and then click the fill handle and drag
across your row or column, Excel will automatically increment the date
by 1 day.

Or, you could set up some formulas in the adjacent cells to
automatically input the incremental dates. For example,

In B1, enter "A1+1"
In C1, enter "A1+2"
In D1, enter "A1+3"
In E1, enter "A1+4"
In F1, enter "A1+5"
In G1, enter "A1+6"

Then in cell A1 enter the starting date.

Is that what you needed?

--JP
 
Thanks! It worked. Now, if I can just add a header that I made in Works. I
try to paste it from my other doc and it says I exceeded the max allowable
number of chars. Well, this is almost done now.
 
Back
Top