Posted to microsoft.public.excel.misc

external usenet poster

Posts: 93

Weekdays of the month.

Am using Excel 2007 and I want to create a list of days of the week for a
month as below I can convert the col 2 info based on Col 1. Any idea on a
formula for creating col 1. A table on another sheet is OK and no problem re
holidays. I just don't want weekend days shown and can't quite noodle it
out.
Col 1 Col2
8/1/07 Wed
8/2/07 Thu
8/3/07 Fri
8/6/07 Mon
8/7/07 Tue

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
Only weekdays (sysgulv)	Systemgulv	Excel Worksheet Functions	5	June 22nd 07 04:54 PM
WEEKENDS VS. WEEKDAYS	TLAngelo	Excel Discussion (Misc queries)	0	July 10th 06 06:49 PM
Number of Weekdays	Vicki	Excel Worksheet Functions	3	May 22nd 06 11:38 PM
Date, Weekdays	Heckstein	Excel Discussion (Misc queries)	3	September 11th 05 10:21 PM
Weekdays	Jeff	Excel Discussion (Misc queries)	7	February 15th 05 12:18 AM

All times are GMT +1. The time now is 11:02 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us