Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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? |
#3
|
|||
|
|||
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? |
#4
|
|||
|
|||
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? |
#5
|
|||
|
|||
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? |
#6
|
|||
|
|||
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? |
#7
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How 2 rotate information in a working shift pattern | Excel Worksheet Functions | |||
When shading cells using the 'pattern' option, they print in grey. | Excel Discussion (Misc queries) | |||
cell pattern displays but will not print | New Users to Excel | |||
Cell Pattern | Excel Discussion (Misc queries) | |||
weekday function | New Users to Excel |