Nested IF statement error

[calcnerd]

I'm having an issue with a nested IF statement I'm trying to build. Here is what I have currently:

=IF(E60<D60,"Early",IF(E60=D60,"On Time",IF(E60>D60,"Late",IF(E60="","In Progress"))))

The problem is when I added the last IF statement Excel is ignoring it. I left cell E60 blank (because the deliverable hasn't been sent yet), but it's returning "Early". Is this because Excel thinks a blank cell is less than a date? Is there a way around this so it can incorporate that "In Progress" option?

Thanks in advance!

 

[calcnerd]

I figured this out. I didn't realize the process order was thrown off. Putting the blank cell part first fixed this issue.