Result the header cell if the when the latest 2 set ends

Dear all,

I want to have a result of the header date when the latest set of 2 ends to where it ends i wana pick the header date but only if the latest cell is 1 than return the formula cell as empty as it has no value in the database.

Thanks in advance.

attached is the file for my data