weekday pattern

M

MichaelSedley

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?
 
B

Bob Phillips

Put the first valid date in A1, and in A2 add

=A1+1+OR(WEEKDAY(A1)=2,WEEKDAY(A1)=5,WEEKDAY(A1)=6)

then copy down

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
M

MichaelSedley

Thanks, a great help - except that Saturdays are still displayng (I.e., now
shows Sun, Mon, Wed, Thur, Sat)
Should be Sun, Mon, Wed, Thur ...

Any idea how I can get rid of Staurday?

M
 
B

Bob Phillips

Sorry about that

=A1+1+OR(WEEKDAY(A1)=2,WEEKDAY(A1)=5)+(WEEKDAY(A1)=5)

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
M

Myrna Larson

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

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

Tushar Mehta

You can also create and use a custom list (Tools | Options | Custom
List tab).

--
Regards,

Tushar Mehta
www.tushar-mehta.com
Excel, PowerPoint, and VBA add-ins, tutorials
Custom MS Office productivity solutions
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top