Return Date Formula

[luisitocarrion1900]

I need this fix that if it has a date in the return column it will count it

=COUNTIFS(List[Activity],Category1,List[Return Date])

 

[Joe4]

Dates are actually stored as numbers in Excel, so all you need to check for is a value greater than zero .
So use ">0" as the criteria argument for your date field.