Example, if I wanted to know the number of Fridays in March of 2007 it would return 5.

 

 

(side note:

I am using this to calculate average x done per hour by day.

This was after realizing that if I used total x per hour for all (fridays) / distict count of dates, I was getting a scewed average because I wasn't counting those dates with zero x's done.  I hope I am going about this in a more efficient manner and not missing something easier)

 

Month

   Weekday

       Hour

          Date

 

April

   Monday

       8 am

         4/23/07

              X1

              X2

                  So the avg X done at 8 am should be 2 / 5 (# of Mon in Apr)

       9 am

         4/2/07

              X1

              X2

         4/16/07

              X3

          4/30/07

              X4

              X5

                  So the avg X done at 9 am should be 5 / 5