Count if This week / Count if last week

[Welsh Mark3]

Looking to create two formulas - One to count instances in the last workweek, the second to count the week before. I think formula one does what I need to do but it looks at the last 7 days rather than the last workweek. The second looks at the last 14 days, can I amend this to show last week?

Formula 1 =COUNTIF(E:E,">="&TODAY()-7)
Formula 2 =COUNTIF(E:E,">="&TODAY()-14)

 

[RasGhul]

Hi Mark,

See if these work? Counting dates for Monday to Friday only?

Book1
	A	B	C		E
1					Dates
2	This week	1			17/01/2022
3	Last Week	7			16/01/2022
4	Week before	3			15/01/2022
5					14/01/2022
6					13/01/2022
7					12/01/2022
8					11/01/2022
9					10/01/2022
10					10/01/2022
11					10/01/2022
12					7/01/2022
13					6/01/2022
14					3/01/2022
15					2/01/2022
16					1/01/2022
Sheet1

Cell Formulas
Range	Formula
B2	B2	=COUNTIFS(E:E,">="&(TODAY())-(WEEKDAY(TODAY(),2)-1),E:E,"<="&(TODAY())-(WEEKDAY(TODAY(),2)-1)+4)
B3	B3	=COUNTIFS(E:E,">="&(TODAY()-7)-(WEEKDAY(TODAY(),2)-1),E:E,"<="&(TODAY()-7)-(WEEKDAY(TODAY(),2)-1)+4)
B4	B4	=COUNTIFS(E:E,">="&(TODAY()-14)-(WEEKDAY(TODAY(),2)-1),E:E,"<="&(TODAY()-14)-(WEEKDAY(TODAY(),2)-1)+4)