Cashflow formula - IF formula issue under date formatted column

kane.godfrey ✭✭
edited 12/09/19 in Smartsheet Basics

Hi, I'm trying to create a project cash flow projection sheet and I'm stuck with the (see attached photo) IF formula. I need the column to be formatted as date to find the IF formula but I cant format the cells below as number/text and I believe this is the reason that the IF formula isn't working. Any help to get this working or work arounds would be appreciated.