"SUMIFS" with "AND" and "@cell" combination returning wrong value

Wes

Where [Begin]@row = DATE(2020, 7, 1) and [End]@row = DATE(2020, 7, 31)

The following formula returns returns incorrect value:

=SUMIFS({Maint-MLR-LaborHours}, {Maint-MLR-DateCompleted}, AND(@cell >= [Begin]@row, @cell <= [End]@row))

But, the following formula returns correct value:

=SUMIFS({Maint-MLR-LaborHours}, {Maint-MLR-DateCompleted}, AND(@cell >= DATE(2020, 7, 1), @cell <= DATE(2020, 7, 31)))

Paul Newcome

Are your Begin and End columns formatted as date type columns in the column properties?