Excel not seeing a cell as blank because it has a formula

[culle1bj]

Hello,

I am trying to create a formula that will tell me if an item is late is there is no completion date entered and if the expected completion date is greater than today. The problem is that the actual completion date is pulling in a "" if there is no value entered on the next tab. That formula is below:

=IF(ACGF!S12=0,"",ACGF!S12)

So if there is no value in S12 on tab ACGF, it is entering "".

Now, when trying to determine if this is late or not, all the ""s are giving me issues. The formula I am trying to use is below:

=IF(completion date>0,"",IF(expected completion date>TODAY(),"LATE",""))

I can attach an example if necessary.

Thank you,
culle1bj

 

[gaz_chops]

Which part of the 2nd formula is referencing the cell with ""?

 

[culle1bj]

The completion date is the cell with "" in it.

 

[gaz_chops]

Does this work?
=IF(AND(completion date="",expected completion date>TODAY()),"LATE","")

 

[culle1bj]

Yes! Thank you! I don't know why I didn't think to set completion date = "".

 

[gaz_chops]

You're welcome, in your 1st formula can you return a 0 instead of ""?