I have a list and would like to do a sumif based upon dates placed in cells.
This works:
=SUMIFS(F:F,A:A,">="&DATE(2024,1,1),A:A,"<="&DATE(2024,1,5))
I would like to do it along the line
=SUMIFS(F:F,A:A,">="&DATE(J2),A:A,"<="&DATE(J3))
I’ve entered the Dates as 1/1/2024, January 1, 2024, even 2024,1,1 and it’s not working.
Obviously I’m missing something basic.
Thx.