Excel Formula (IF Function)

  • Thread starter Thread starter Glenn Robertson
  • Start date Start date
G

Glenn Robertson

Hi hope someone can help,

I have a spreadsheet with 3 main columns.

Column A = Run Date (format dd/mm/yyyy)
Column B = Run Processed (format dd/mm/yyyy)
Column C = Days on Target (Number)

Currently I have told Column C that if you minus Column B
from Column A it tells you in Column C how many days early
or late the run was by putting either a plus number or a
minus number.

At the moment if there is a date in Column A but no date
in column B column C gives me a ridiculous amount of -
34562. Is there any way I can put a formula in Column C
that will take away column B from column A but if there is
no info in column B it will put 0 in column C.

Many Thanks
Glenn Robertson
 
Back
Top