SUMPRODUCT issue with Dates

[Sufiyan97]

I know I am making some mistake in the formula

I want result for only January which should be 5, but it gives result 44 for entire range

Book3
	A	B	C	D	E	F	G	H	I	J	K	L	M
1
2			1/1/2022	1/2/2022	2/2/2022	3/2/2022	4/2/2022	5/2/2022	6/2/2022	7/2/2022
3	Income		2	3	4	5	6	7	8	9		44
4	Expenses		1	2	3	4	5	6	7	8
5
6
7
8
Sheet1

Cell Formulas
Range	Formula
E2:J2	E2	=EDATE(D2,1)
D3:J4	D3	=C3+1
L3	L3	=SUMPRODUCT(($C$2:$J$2&"&">="&01/01/2022)*($C$2:$J$2&"&"<="&1/31/2022)*($A$3:$A$4="Income")*(C3:J4))

 

[Sufiyan97]

Some how I got it solved by myself, thanks everyone who tried to solve it.

Book3
	A	B	C	D	E	F	G	H	I	J	K	L	M
1
2			1/1/2022	1/2/2022	2/2/2022	3/2/2022	4/2/2022	5/2/2022	6/2/2022	7/2/2022		Jan Total Income
3	Income		2	3	4	5	6	7	8	9		5
4	Expenses		1	2	3	4	5	6	7	8
5
6
Sheet1

Cell Formulas
Range	Formula
E2:J2	E2	=EDATE(D2,1)
D3:J4	D3	=C3+1
L3	L3	=SUMPRODUCT(($C$2:$J$2>=DATE(2022,1,1))*($C$2:$J$2<=DATE(2022,1,31))*($A$3:$A$4="Income")*(C3:J4))

 

[Fluff]

How about

=SUMPRODUCT(($C$2:$J$2>=DATE(2022,1,1))*($C$2:$J$2<=DATE(2022,1,31))*($A$3:$A$4="Income")*(C3:J4))

 

[Sufiyan97]

Thank you very much Fluff, working perfectly

 

[Fluff]

You're welcome & thanks for the feedback.