Struggling with Excel Formulas for Attendance Tracking? Let's Solve It Together

I am Rajesh Kumar, Senior Executive - HR. I want a formula in an Excel sheet with two conditions. I hope my query is very small to all of you. Please help me. I am working on an employee attendance sheet in Excel.

Regards,
Rajesh Kumar
[Phone Number Removed For Privacy Reasons]

Dear KarthikSheela;2099162, I am Rajesh. Yes, let me explain something better. My purpose is that I am working on updating the employee attendance sheet daily. Therefore, I need a formula to calculate the same.

Regards,
Rajesh

If I understand correctly, your attendance policy dictates that a WO cannot be taken between two absences. If one is absent on either side of a WO, they will be marked absent for that WO as well.

If so, please find attached an Excel sheet with a macro that will tabulate the same for you. All you need to do is enter the data in the format and click on the button in the top-left corner.

Regards.