You mean August not July

=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(DATE(2006,8,1)&":"&DATE(2006 ,9,0))))=3))

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"CheapTequila" wrote in message
ps.com...
Hello - I'm building a spreadsheet that is supposed to calculate how
many times a particular day of the week appears in the month for a
billing letter. Students are scheduled for a lesson on one of the days
of the week, and based on that day, I want to count how many times that
day appears in a given month and calculate their bill. For example,
there are 5 Tuesdays, Wednesdays and Thursdays in July 2006, but only 4
Fridays, Saturdays, Sundays and Mondays. I've got a column for the
date, and another column for the day (Monday, Tues. etc.) Is there some
function in Excel that would help do this or a formula or algorithm?
Thanks!