On 7 Aug 2006 01:14:21 -0700, "CheapTequila" wrote:

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!

To calculate the number of a particular weekday in a month:

=4+(MONTH(A1+35-WEEKDAY(A1+7-WDN))=MONTH(A1))

where A1 contains day 1 in the month (e.g. 1 AUG 2006) and WDN is the weekday
number (1=Sun, 2=Mon, etc).


--ron