View Single Post
  #20   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bob Bob is offline
external usenet poster
 
Posts: 972
Default days of the week formulas

the beginning of the month would start as the formula states (first Monday of
a calendar month. The previous month ends the Sunday before that date.

February ended on Sunday, March 2 and March began on Monday, March 3.

March ends on Sunday April 6 and April begins Monday April 7.

"Ron Rosenfeld" wrote:

On Fri, 7 Mar 2008 08:24:04 -0800, Bob wrote:

The first day of the broadcast month does not always correspond with first of
the calendar month.
The first day of the broadcast month always begins with a Monday (regardless
of the what day of the week the 1st is) and the last day of the month always
ends on a Sunday.
TV scheduling is funny that way.


Bob,

Your "rules", as I understand them, result in some overlap. How does that get
dealt with in the broadcast world?
--ron