View Single Post
  #1   Report Post  
GregR
 
Posts: n/a
Default 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