No answer if cell blank
I'm subtracting 2 dates. If the dates are <=5 then the answer is Y, if not then the answer is N. How do I ignore blank cells so I don't automatically get a Y? This is the formula I'm using.
=IF(G2-C2<=5,"Y","N")
One way among many others is to use ISBLANK, OR, and nested IFs:
=IF(OR(ISBLANK(C2),ISBLANK(G2)),"",IF(G2-C2<=5,"Y","N"))