If I understand your business in a right way ... you may need to calculate in a daily bases what is outstanding (Last state is open or none), and what is not outstanding (the last state is close ....
Firstly, modify your data source to allow all the records to be calculated against fixed time table (27 March, 28 March, 29 March and 4 April), include another sheet that contain these time table and cross join to it with your initial data table ... now for each day from this time table you need to identify per each (global ID) the last opening date and the last closing date corresponding to this day, then compare them to decide if the status was closed or opened in that day ...
The below VIZ try apply this on your sample data, the resultant view display the (global IDs) distributed against the days from the time table and calculate per cell the last opening date, the last closing date and the status and the expected status ....
and here is the VIZ link
If you found this helpful, Please mark it as helpful post, or as the correct answer
Thanks for this, are you able to save in version 10.1 though? I only have 10.1 here so cannot access your attachment