Thank you everyone. All of your suggestions/advice were quite helpful.

As "At Printer was the first location stop and "In Stock" was the final
destination, the solution I needed was =IF(AH7DATE(2001,1,1),"In
stock",IF(W7DATE(2001,1,1),"At printer","")).