How to use a formula which may contain a cell with no data

Hello there

I have 7 columns which each should have a date entered to record a transaction, these are Column K (for a start date), and attendance dates in O,P,Q,R,S, and T. I need column U to show a "Y when columns O,P,Q,R,S,T have a date entered or "N" if any of the columns, O,P,Q,R,S,T have no date entered. I also need the calculation to show "N" if column K is empty.

I'm rubbish with formulas - can anyone help?

thanks in appreciation

Duckersj

Title updated....

Please Login or Register  to view this content.