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:

JAN

FEB

MAR

APR

MAY

JUN

JUL

AUG

SEP

OCT

NOV

DEC

<colgroup><col span="2"><col span="2"><col span="2"><col><col span="5"></colgroup><tbody>
</tbody>

 

[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?

JAN	FEB	MAR	APR	MAY	JUN	JUL	AUG	SEP	OCT	NOV	DEC
'=WednesdaysInMonth*28.46	'=WednesdaysInMonth*28.46	etc.

<tbody>
</tbody>

 

[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.