Thread: weekday pattern
View Single Post
  #6   Report Post  
Dana DeLouis
 
Posts: n/a
Default

Just a different idea...

=A1+MOD(3313,WEEKDAY(A1)+5)

--
Dana DeLouis
Win XP & Office 2003


"MichaelSedley" wrote in message
...
Hi,

I'm trying to create a column which automatically shows all the Sundays,
Mondays, Wednesdays and Thursdays in a month (skipping Tuesdays, Fridays,
Saturdays).

Is this possible?