I have been "volunteered" to set up a spreadsheet to speed up the tuition statements at the daycare center I work in. I have a nodding acquaintance with Excel but have no idea how do determine the number of Monday's or any other day of the week there are in a given month.

Our children attend the center from two days to five days a week, some half day and some full day. Each child attends the same days of the week. What is needed is a way to calculate the number individual days per month (i.e.: Mondays) in a given month.

The rest of the spreadsheet will be a piece of cake (I hope), I simply would multiply the number of Monday's times the appropriate fee, then the number of Tuesday's times the appropriate fee and so on. The total would then be billed.

Thank you in advance for all your help.

Carol