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!
|