"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?

Wes

Yes

Paul Newcome

How are the dates in the Begin and End columns populated?