Myrna Larson

Posts: n/a

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?

Reply With Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
How 2 rotate information in a working shift pattern	Xeraco	Excel Worksheet Functions	3	March 25th 05 03:56 AM
When shading cells using the 'pattern' option, they print in grey.	Todd	Excel Discussion (Misc queries)	0	March 11th 05 06:37 PM
cell pattern displays but will not print	Noble1	New Users to Excel	1	March 1st 05 05:38 AM
Cell Pattern	Peter M	Excel Discussion (Misc queries)	2	January 11th 05 02:13 AM
weekday function	John	New Users to Excel	0	January 7th 05 11:13 AM

All times are GMT +1. The time now is 10:05 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us