Formula for SUMIFS, criteria between date

[wongsiuon]

Hi,
i write a SUMIFS with two criteria.
First criteria is C2. in Column D:D
The second criteria is between Dates (between 20th Feb to Today) in Column V:V

However, i write the below formula. It is not correct. Do you know what is correct syntex formula? thanks a lot.


=SUMIFS(S:S,D:D,C2,V:V,"=>"&2/20/2024",V:V,"<="&TODAY())

[Fluff13]

How about

=SUMIFS(S:S,D:D,C2,V:V,"=>2/20/2024",V:V,"<="&TODAY()) 

or

=SUMIFS(S:S,D:D,C2,V:V,"=>"&date(2024,2,20),V:V,"<="&TODAY())