Thread: weekday pattern
View Single Post
  #5   Report Post  
Myrna Larson
 
Posts: n/a
Default

With the first date in A1, put this formula in A2:

=A1+CHOOSE(WEEKDAY(A1),1,2,1,1,3,2,1)

On Thu, 31 Mar 2005 04:37:05 -0800, "MichaelSedley"
wrote:

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?