Good morning,
I'm having some trouble executing an IF formula that relies on a few different factors to determine if a project was completed by the due date or the adjusted due date, if applicable. See the attachment:
Each project is assigned a due date however the due date can be adjusted so in some cases a project may have data entered for both a due date and an adjusted due date. When the project is complete, the completion date is entered. I need the final column to result in a yes or no response if either of these due dates was met. If the project is not yet complete this would remain blank.
I attempted using an OR formula but am not yielding the results I had hoped for. In my example everything is coming back as Yes, however in my actual file I am receiving #Value errors on the cases that should be no using this same formula.
Thank you in advance!
Bookmarks