Fill Mon-Wed-Fri dates?
Hi. Just another option.
If A1 has a M,W, or F date, then perhaps...
=A1+MOD(17,WEEKDAY(A1)+1)
If A1 has a Tues, or Thur date...
=A1+MOD(12,WEEKDAY(A1)+2)
--
HTH :)
Dana DeLouis
"LynneCreek" wrote in message ...
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!
|