Project Completed If Date Entered
I am trying to extract a confirmation from a row containing dates. The objective of the following formula is to determine if a date has been entered and if so, display the number 1. If not, to Display a zero. Note, the formula works when information is not entered in to a DATE column, however when the cell is blank, it produced the first option of "1". My assumption is that there is something wrong with the Columns with regards to Formatting Text vs Date. As well as the last comment in the formula.
...IF(AND([Input Complete Date]6 >= [Planned End Date]6, [Input Complete Date]6 > 0), 0, "1")
Input Complete Date1
Planned End Date1
Complete (where the formula sits)