Tracking Open Items Against Dates

[bradjsteve88]

I am wanting STATUS cell to read "OPEN" if a date has been input in the RECOGNISED cell but "CLOSED" if a date has been input in CLOSED cell.

Apex - IMDE Tracking Sheet.xlsx
	D	E	F	G	H	I
2	Recognised	Forecasted	Actual	Closed	Days Open	Status
3
4	24-01-22	28-01-22	27-01-22	27-01-22
5	24-01-22	28-01-22
6
Sheet1

Cells with Conditional Formatting
Cell	Condition		Cell Format	Stop If True
I5:I10	Cell Value	contains "Delayed"	text	NO
I5:I10	Cell Value	contains "Accepted"	text	NO
I5:I10	Cell Value	contains "Paid"	text	NO
I5:I10	Cell Value	contains "On Track"	text	NO

 

[shift-del]

Hi

=IF(G4>0,"CLOSED",IF(D4>0,"OPEN",""))

 

[bradjsteve88]

Hi

=IF(G4>0,"CLOSED",IF(D4>0,"OPEN",""))

Thanks for the quick response and simple answer.