Annabelle,

Your original formula was flawed as it didn't properly test a date (put any
date and see), but this caters for the amend

=IF(W7--"2001-01-01","At Printer",IF(AH7--"2001-01-01","In Stock",""))


--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"Annabelle" wrote in message
oups.com...
This formula works adds At Printer to O7.

=IF(W71/1/2001,"At Printer","")

Having difficulty adding another possibility: If W7 1/1/2001, "At
Printer","" Or AH 1/1/2001, "In Stock", ""

In english - if there is a date in W7, then insert "At Printer or if
there is a date in AH7, then insert "In Stock".


Can you assist?