| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Count # of Saturdays in a month
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. -- Dave "Life''s A Kick!" |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Count # of Saturdays in a month
Try this:
Dates in the range A1:A10 =SUMPRODUCT(--(A1:A10<""),--(WEEKDAY(A1:A10,2)=6)) Biff "Dave" wrote in message ... 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. -- Dave "Life''s A Kick!" |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| count work days excluding Fridays and Saturdays ??? | Excel Worksheet Functions | |||
| Count Saturdays in a List | Excel Worksheet Functions | |||
| Count the dates in a month | Excel Discussion (Misc queries) | |||
| count by month | Excel Worksheet Functions | |||
| PivotTable - Count by Month | Excel Worksheet Functions | |||
Linear Mode
