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.
Bookmarks