View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
John C[_2_] John C[_2_] is offline
external usenet poster
 
Posts: 1,358
Default Fill Mon-Wed-Fri dates?

down and dirty
A2: 8/4/08 (or some other day that is definitely Mon, Wed, or Fri)
A3: =A2+2*OR(WEEKDAY(A2)=2,WEEKDAY(A2)=4)+3*(WEEKDAY(A 2)=6)
Copy A3 down as needed.

or, for Tue / Thu
A2: 8/5/08 (or some other day that is definitely Tue or Thu)
A3: =D2+2*(WEEKDAY(D2)=3)+5*(WEEKDAY(D2)=5)

Hope this helps.
--
John C


"LynneCreek" wrote:

I'm a college instructor and would REALLY like to find a way to automatically
fill the dates for MWF classes or for T-Th classes. So far all I can get
excel to do is either weekdays or every-other day. Any suggestions would be
helpful!