Manish welcome to the forums! Please help us help you by posting a packaged workbook that is connected to your two sheets. We just need one or two dummy employees with start//end dates and the corresponding holiday table. If you are unfamiliar with attaching a workbook watch this video:
It has lots of other great tips.