Busy week of the month

  • Thread starter Thread starter Jim
  • Start date Start date
J

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?
 
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
 
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.
 
Back
Top