Good morning
If someone could please assist with the following, I get the formulas to work each individually. Next set would be to get all of it to work together. I know there is probably a very easy solution to this, as a noob it proves to be difficult.
N2 should indicate "Open" or "Closed". If M2 has value in it (a date), N2 should display "Open".
Thereafter when a value is entered into O2 (a date), it should change to "Closed". It will always be in that order, first value into M2, several days later a value (Date) will be entered into O2.
Last part, M2 may have a date or "info" in cell. When "Info" is entered N2 should also indicate "Closed".
Thank you in advance for the assistance.
Bookmarks