How can I use IF, Vlookup and index & match effectively for the leave register

[Joel]

Hello team please assist on how can I introduce a date range on Leave Table sheet to capture days taken by employees on actual dates on leave calendar sheet, days utilized, days carried forward and actual leave balances assuming an employee earns 2 days per month on this sheet.

 

[Aniruddah Alam]

Hello team please assist on how can I introduce a date range on Leave Table sheet to capture days taken by employees on actual dates on leave calendar sheet, days utilized, days carried forward and actual leave balances assuming an employee earns 2 days per month on this sheet.

Dear Joel,

Thank you for your post on our Exceldemy forum. Could you provide more details about your requirements?

Regarding the Leave Table sheet, would you like to have a single row for each employee? If so, how would you like to store the days when an employee takes leave on multiple days?

Looking forward to your response.

Best regards.