On Thu, 8 Dec 2005 08:43:54 -0600, harnagel
wrote:


How do I calculate how many Mondays, Tuesdays, Wednesdays, etc. were
worked in a month based on this:

A1 B1
Date Day of Week (based on calculation)
Date Day of Week
Date Day of Week
ETC

Sum = How many Mondays, Tuesdays, Wednesdays, etc. worked in the month

Repeating the same question without responding to the previous suggested
solutions with the problems that arose in implementing them is unlikely to be
productive.

I suggest that your failure to obtain a useful solution is likely related to
the fact that no one, as yet, has been able to understand exactly what you
mean.

Perhaps if you gave examples of actual inputs and desired outputs, you might
have more success.


--ron