AverageIFS with =today()

[Bandito1]

Hello all,

Want the average of the numbers in column D based on the month it is.
Made this formula for it;

=AVERAGEIFS(D338:D368;A338:A368;">="&E338;A338:A368;"<="&EOMONTH(E338;0))

Now when i enter 1-12-2022 in cell E338 it works
But when i place =today() there and the value 29-12-2022 appears it takes the value from 29-12-2022 and doesn't calculate the average.

What is going wrong?

Tracker QA on the floor New.xlsm
	A	B	C	D	E	F
338	01-Dec-22	1	3	51	1-12-2022	44,29032
339	02-Dec-22	0	5	46	29-12-2022	37
340	03-Dec-22	0	1	48
341	04-Dec-22	0	5	48
342	05-Dec-22	10	8	44
343	06-Dec-22	6	6	45
344	07-Dec-22	3	7	41
345	08-Dec-22	4	3	39
346	09-Dec-22	1	6	38
347	10-Dec-22	0	2	34
348	11-Dec-22	1	2	41
349	12-Dec-22	2	5	38
350	13-Dec-22	15	4	44
351	14-Dec-22	1	4	41
352	15-Dec-22	9	3	47
353	16-Dec-22	9	2	54
354	17-Dec-22	0	1	53
355	18-Dec-22	0	3	50
356	19-Dec-22	9	4	55
357	20-Dec-22	1	2	54
358	21-Dec-22	2	0	56
359	22-Dec-22	4	10	50
360	23-Dec-22	1	3	48
361	24-Dec-22	0	4	44
362	25-Dec-22	0	3	41
363	26-Dec-22	0	2	39
364	27-Dec-22	0	3	36
365	28-Dec-22	4	3	37
366	29-Dec-22	0	0	37
367	30-Dec-22	0	0	37
368	31-Dec-22	0	0	37
BMR's in kast

Cell Formulas
Range	Formula
A338:A368	A338	=$A$2+ROWS($1:335)-1
B338:B368	B338	=IF(A338="","",SUMPRODUCT(--('Tracker QA on the Floor'!$J:$J=A338)))
C338:C368	C338	=IF(A338="","",SUMPRODUCT(--('Tracker QA on the Floor'!$L:$L=A338)))
F338:F339	F338	=AVERAGEIFS(D338:D368,A338:A368,">="&E338,A338:A368,"<="&EOMONTH(E338,0))
E339	E339	=TODAY()
D351:D368	D351	=IF(AND(B351=0,C351=0),D350,SUM(D350)+(B351)-C351)

 

[RoryA]

If you put TODAY in there, your first criterion is then >=29/12/2022. You could use:

=AVERAGEIFS(D338:D368;A338:A368;">="&EOMONTH(E338;-1)+1;A338:A368;"<="&EOMONTH(E338;0))

 

[Bandito1]

Thank you very much, that works