Hi Duane.

Am Wed, 7 Oct 2020 06:55:32 -0500 schrieb dpb:

That documented anywhere, Claus?

I didn't see it anywhere.

You don't need the ampersand if you insert the date as string:
Use:
=SUMIF(G1:G10,""&DATE(2020,2,18),J1:J10)
or
=SUMIF(G1:G10,"18.02.2020",J1:J10)


Regards
Claus B.
--
Windows10
Office 2016