=FILTER

[j4ymf]

Hello All

I have this formula, is there any chance i can add to it to only return the last 7 days within a date range.

=FILTER('30Days'!table,'30Days'!E:E=C13,"")

somthing like this but guessing.?
=FILTER('30Days'!table,'30Days'!E:E=C13,"") "30/03/2024 - 05/04/2024"
or
=FILTER('30Days'!table,'30Days'!E:E=C13,"") "=NOW() - 7

 

[arthurbr]

See method 4 of this link and replace 30 with 7

 

[Cubist]

Can you post sample data? Which column is the date in?

 

[etaf]

that is filtering the table based on column E equalling C13 - so not sure what that is

BUT you can filter with various criteria
=filter( TABLE , (Column =

=FILTER(A3:E18,(B3:B18>=DATEVALUE("1/5/24"))*(B3:B18<=DATEVALUE("1/7/24")))

so ......)*(....... as criteria means all apply AND
......)+(....... as criteria means any apply OR

Book2
	A	B	C	D	E	F	G	H	I	J	K
1
2			weeknumber	weeknum calc	days
3	Mon	1/1/24	1
4	Tue	4/30/24	18	18	17.14		5/31/24	45443	22	22	21.5714286
5	Sun	3/31/24	14	13	12.86		6/30/24	45473	27	26	25.8571429
6	Thu	10/31/24	44	44	43.43
7	Wed	1/31/24	5	5	4.29
8	Thu	2/29/24	9	9	8.43
9	Sun	3/31/24	14	13	12.86
10	Tue	4/30/24	18	18	17.14
11	Fri	5/31/24	22	22	21.57
12	Sun	6/30/24	27	26	25.86
13	Wed	7/31/24	31	31	30.29
14	Sat	8/31/24	35	35	34.71
15	Mon	9/30/24	40	39	39.00
16	Thu	10/31/24	44	44	43.43
17	Sat	11/30/24	48	48	47.71
18	Tue	12/31/24	53	53	52.14
Sheet4

Cell Formulas
Range	Formula
C3:C18	C3	=WEEKNUM(B3)
D4:D18	D4	=WEEKNUM(B4-$B$3)
E4:E18	E4	=DAYS(B4,$B$3)/7
G4:K5	G4	=FILTER(A3:E18,(B3:B18>=DATEVALUE("1/5/24"))*(B3:B18<=DATEVALUE("1/7/24")))
A3:A18	A3	=B3
B7:B18	B7	=EOMONTH(O1,0)
Dynamic array formulas.