Hi all,
I'm trying to construct an IF statement to determine which items were discarded after their expiration date.

IF an item has an expiration date, and IF the discard date > expiration date, then put a 1 in the cell. If no expiration date then do nothing.

Here is what I have so far.. which seems to only count when there is an expiration date for the item, regardless of whether the discard date > expiration date.

=IF((Table1[[#This Row],[expirationdt]])="","",IF((Table1[[#This Row],[Date Discarded]])>(Table1[[#This Row],[expirationdt]]),"",1))

Any suggestions?
Thanks.