Formula for the number of certain weekdays in a month

[roxdrob]

Hi, I am trying to create a formula that will calculate the number of Wednesdays in a month and multiply it by 28.46. How would I do that?

TIA

Edited to add:

My columns are months:
[TABLE="width: 661"]
<colgroup><col span="2"><col span="2"><col span="2"><col><col span="5"></colgroup><tbody>[TR]
[TD] JAN [/TD]
[TD] FEB [/TD]
[TD] MAR [/TD]
[TD] APR [/TD]
[TD] MAY [/TD]
[TD] JUN [/TD]
[TD] JUL [/TD]
[TD] AUG [/TD]
[TD] SEP [/TD]
[TD] OCT [/TD]
[TD] NOV [/TD]
[TD] DEC [/TD]
[/TR]
</tbody>[/TABLE]

 

[Dave Patton]

Try the alternative that you prefer.

F4 "Feb" is an actual date (Feb 1, 2018) for the relevant year ; formatted as Feb "mmm".

Excel 2010
	A	B	C	D	E	F
1	1-Feb-18	4	4	4
2
3	1-Feb-18	28-Feb-18		4
4						Feb
5						4
6
4a

Cell Formulas
Range	Formula
B1	=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A1&":"&EOMONTH(A1,0))))=4))
B3	=EOMONTH(A3,0)
C1	=SUMPRODUCT(--(WEEKDAY(ROW(INDIRECT(A1&":"&DATE(YEAR(A1),MONTH(A1)+1,0) )))=4))
D1	=NETWORKDAYS.INTL(A1,EOMONTH(A1,0),"1101111")
D3	=NETWORKDAYS.INTL(A3,B3,"1101111")
F5	=NETWORKDAYS.INTL(F4,EOMONTH(F4,0),"1101111")

Named Ranges
Name	Refers To	Cells
Int	='2a'!$B$4

 

[roxdrob]

Thank you for your answer, but I'm a little confused. Will that work with this format?

[TABLE="class: grid, width: 500"]
<tbody>[TR]
[TD]JAN[/TD]
[TD]FEB
[/TD]
[TD]MAR
[/TD]
[TD]APR
[/TD]
[TD]MAY
[/TD]
[TD]JUN
[/TD]
[TD]JUL
[/TD]
[TD]AUG
[/TD]
[TD]SEP
[/TD]
[TD]OCT
[/TD]
[TD]NOV
[/TD]
[TD]DEC
[/TD]
[/TR]
[TR]
[TD]'=WednesdaysInMonth*28.46
[/TD]
[TD]'=WednesdaysInMonth*28.46
[/TD]
[TD]etc.
[/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]

 

[Dave Patton]

Did you try one of the alternatives to calculate the number of days and * 28.46?

 

[roxdrob]

I just got it. Thanks for your help.