GregR

Posts: n/a

Weeks in a Calendar

I have a spreadsheet where I want to break up the weeks of the month by each
month. The work week begins Sat @12:01AM and ends Friday at midnight. For
instance JAN 05 would look like:
Wk1 Wk2 Wk3 WK4 Wk5 Wk6
1-7 8-14 15-21 22-28 29-31

July 05 would be:
Wk1 Wk2 Wk3 WK4 Wk5 Wk6
1 2-8 9-15 16-22 23-29 30-31

and so on. TIA

Greg

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
Ploting dates against a calendar and not as a simple events	Barb Reinhardt	Charts and Charting in Excel	2	January 22nd 05 02:41 AM
Calendar 13 Periods 4 weeks each	CHawk@Mcc	Excel Discussion (Misc queries)	2	December 10th 04 04:27 PM
Problem with data using IF and Nested IF statements possibly???	Ajay	Excel Discussion (Misc queries)	2	December 9th 04 09:23 AM
Fiscal Calendar	Eileen	Excel Discussion (Misc queries)	1	November 27th 04 09:29 AM
calendar spreadsheet	G Graham	Excel Discussion (Misc queries)	1	November 26th 04 05:38 PM

All times are GMT +1. The time now is 03:36 PM.

About Us

"It's about Microsoft Excel"

Menu

About Us