How Many Weeks in a Quarter of a given year

[ManUBlueJay]

I am trying to determine how many weeks are in a given Excel Quarter (Standard, not ISO)
I cannot just use 13 as there are some Quarters that are 14. Like this year.
The data I have to work with is the Year cell (A1), and the Quarter, cell (A2)
A1 = 2020
A2 = Q1

 

[jasonb75]

How are you counting the weeks? The method that I use doesn't return any 14 week quarters this year.

 

[sandy666]

like this for whole 2020?

Qty	CountWeeks
1	13
2	13
3	13
4	14

 

[Dave Patton]

Question is not complete. How do you define the weeks?

T10_1505a.xlsm
	A			D	E	F	G	H
1								Weeks in year, quarter
2					Quarter 1	Quarter 2	Quarter 3	Quarter 4
3	2015			53	13	13	13	14
4	2016			52	13	13	13	13
5	2017			52	13	13	13	13
6	2018			52	13	13	13	13
7	2019			52	13	13	13	13
8	2020			53	13	13	13	14
3a

Cell Formulas
Range	Formula
D3:D8	D3	=NETWORKDAYS.INTL(DATE(A3,1,1),DATE(A3,12,31),"1110111")
E3:E8	E3	=NETWORKDAYS.INTL(DATE(A3,1,1),EOMONTH(DATE(A3,1,1),2),"1110111")
F3:F8	F3	=NETWORKDAYS.INTL(DATE(A3,4,1),EOMONTH(DATE(A3,4,1),2),"1110111")
G3:G8	G3	=NETWORKDAYS.INTL(DATE(B3,7,1),EOMONTH(DATE(B3,7,1),2),"1110111")
H3:H8	H3	=NETWORKDAYS.INTL(DATE(B3,10,1),EOMONTH(DATE(B3,10,1),2),"1110111")

 

[sandy666]

for few years

Year	1	2	3	4
2015	13	13	13	14
2016	13	13	13	14
2017	13	13	13	14
2018	12	13	14	14
2019	13	13	13	14
2020	13	13	13	14

I agree with

Question is not complete. How do you define the weeks?