View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.misc
Janet BN Janet BN is offline
external usenet poster
 
Posts: 14
Default Week of the Month

Hi Dave,
We have a 7 days per week schedule so the 1st week of the month can fall on
any day and is the one that contains the 1st day of the month.

Thanks
"Dave O" wrote:

This is trickier than it sounds, because a month can start on a Friday
or Saturday- does the first of that month constitute week one? How do
you define a week?