Thread: Referencing a cell with a date, not working.

I have the following in a cell:

=SUMPRODUCT('\\Znas1\dept_docs\MFG\Org4Riley\IEC109_110FA\ContinuousImprovement\[OEE_109FA.xlsm]Line Data Table'!$L$1:$L$9000,
    --('\\Znas1\dept_docs\MFG\Org4Riley\IEC109_110FA\ContinuousImprovement\[OEE_109FA.xlsm]Line Data Table'!$A$1:$A$9000=K1),
    --('\\Znas1\dept_docs\MFG\Org4Riley\IEC109_110FA\ContinuousImprovement\[OEE_109FA.xlsm]Line Data Table'!$D$1:$D$9000=1),
    --('\\Znas1\dept_docs\MFG\Org4Riley\IEC109_110FA\ContinuousImprovement\[OEE_109FA.xlsm]Line Data Table'!$B$1:$B$9000="IEC109-1"))

Problem is, cell K1 contains dates. If I enter the date, say 6/27/11, my code works and the data is successfully pulled from the OEE_109FA.xlsm file. However if I use something like =now()-2, it doesn't work and my returned values are always 0 from my OEE_109FA.xlsm file. Is there any reason why I can't reference a date from a formula with my sumproduct? thanks

arthurbr,

Thank you for your response; I'm not sure what you're referring to, would you care to elaborate? thank you.