On Oct 25, 12:20 pm, "Chip Pearson" wrote:
What are you trying to do with



If you're looking for date, loose the 'OC' prefix. DATE isn't a cell
reference.

Thanks for the responses guys. The thing I should have mentioned is
that "OC" is actually a sheet name. So essentially with the statement:
IF(OC!I3:I9999<OC!Date(2007,6,6),0) I'm trying to say that "If the
date in column I on sheet OC is less than June 6, 2006.... as a
condition.