View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dana DeLouis Dana DeLouis is offline
external usenet poster
 
Posts: 947
Default 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!