Counting Different Types of Leave

So Joe is taking three leaves, but when he informed me, you can see the timestamp column "A" and the start date column "C" in that leave. He informed me one day in advance, so two day of leave should be counted as Emergency Leave, but the next one day will be counted as Planned Leave. I'm in the same boat as David; I'm not sure what to do or how to do it! Please assist me in this; I would be extremely grateful.
I think it should be counted using nature of leave or, start date and end date too.

Below is the image for your reference:-

Capture.PNG