View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.newusers
Donald[_2_] Donald[_2_] is offline
external usenet poster
 
Posts: 2
Default Date Calculation

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)