Busy week of the month

[Jim]

Column A has dates over the last 5 years (i.e. 07/31/2003)

looking for a function that works like WEEKDAY function.

Trying to understand: Which week in a month is the
busiest?

 

[Jason Morin]

I inserted several hundred random dates in column A. In
column B I used the formula:

=WEEKNUM(A2)&"-"&YEAR(A2)

and filled down. I then did a Pivot Table (col. B header
in ROW, count of col. B in DATA). I then (by year) picked
out the weeknum's with the highest count and translated
that to a week-by-month number (eg 13-2003 = 13th week of
2003 = last week in March 2003).

HTH
Jason
Atlanta, GA

 

[RaySny57]

What criteria are you using to establish "busiest"? Work orders,
repairs, sales counts, units produced, etc.,. When you know that you
can isolate using the =MAX() function and then you the result in an
=INDEX to return cell coordinates which inturn can be used to isolate
the date or week # you want.