weekday pattern
 

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?

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)


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

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


"Bob Phillips" wrote:

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)


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

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)


"MichaelSedley" wrote in message
...
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


"Bob Phillips" wrote:

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)


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

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?

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?

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

In article ,
says...
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?