Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need a way to determine the # of Saturdays in a month
Hi all,
I need to determine the # of Saturdays in a given month. Can anyone help? -- TIA Chuck M. |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need a way to determine the # of Saturdays in a month
Try this:-
=SUM(IF(WEEKDAY(A1-1+ROW(INDIRECT("1:"&TRUNC(B1-A1)+1)))=C1,1,0)) A1= Start date B1 = End date C1 = day of week you want 1=Sun - 7 = Sat It's an array so Ctrl+Shift+enter Mike "Chuck M" wrote: Hi all, I need to determine the # of Saturdays in a given month. Can anyone help? -- TIA Chuck M. |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need a way to determine the # of Saturdays in a month
Thats it! Thanks Mike.
-- Thanks. Chuck M. "Mike H" wrote: Try this:- =SUM(IF(WEEKDAY(A1-1+ROW(INDIRECT("1:"&TRUNC(B1-A1)+1)))=C1,1,0)) A1= Start date B1 = End date C1 = day of week you want 1=Sun - 7 = Sat It's an array so Ctrl+Shift+enter Mike "Chuck M" wrote: Hi all, I need to determine the # of Saturdays in a given month. Can anyone help? -- TIA Chuck M. |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need a way to determine the # of Saturdays in a month
try this where a1 contains any date in the month desired
=SUMPRODUCT(--(WEEKDAY(A1-1+ROW($A$1:INDEX(A:A,DAY(EOMONTH(A1,0)))))=7)) or start date in a1 and end date in a2 =SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(a1&":"&a2)))=7)) -- Don Guillett Microsoft MVP Excel SalesAid Software "Chuck M" wrote in message ... Hi all, I need to determine the # of Saturdays in a given month. Can anyone help? -- TIA Chuck M. |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Need a way to determine the # of Saturdays in a month
Another one:
A1 = any date in the month of interest =4+(DAY(A1-DAY(A1)+35)<WEEKDAY(A1-DAY(A1)-DOW)) Where DOW = Monday = 1 to Sunday = 7 -- Biff Microsoft Excel MVP "Chuck M" wrote in message ... Hi all, I need to determine the # of Saturdays in a given month. Can anyone help? -- TIA Chuck M. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Count # of Saturdays in a month | Excel Discussion (Misc queries) | |||
How to determine the number of month between 2 periods? | Excel Discussion (Misc queries) | |||
How to determine the number of month between 2 periods? | Excel Worksheet Functions | |||
Count Saturdays in a List | Excel Worksheet Functions | |||
Skipping Saturdays and Sunday | Charts and Charting in Excel |