How can you use the( =small) equation using dates with cells that have a
zero. I want the equation to ingnore cells with zero and only look at cells
with a date.

i.e
Last TRN Last Receipt Last Issue Last Ship
20080506 20080307 0 20080229