Count # of Saturdays in a month

G

Guest

Excel 2003. I am looking for a formula that looks at a range of cells that
have the days/dates of the month and will count just the saturdays in any
given month. The cells with dates are formulated to have the actual weekday
name I.e "Saturday, Jan 26, 2008". The "countif" and "sumif" functions do not
seem to recognize the "Saturday" letters even when using the*. Any help would
be greatfully appreiciated.
 
T

T. Valko

Try this:

Dates in the range A1:A10

=SUMPRODUCT(--(A1:A10<>""),--(WEEKDAY(A1:A10,2)=6))

Biff
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Count the Number of Weekdays by Month 3
Access Count dates within a Month 4
taking a count 3
Re: How can I count the number of SATURDAYS in a month? 0
No. of Saturdays between 2 dates 5
NETWORKDAYS function 1
Counting Days of Week 2
count total dates for each month 2

Top