How Can I Create an Excel Sheet for Tracking Attendance and Calculating Salaries in Construction?

My company is a construction company. Most of the employees stay at the site or in rooms provided by the company. Employees go on leave after three or four months for ten to fifteen days.

Now, I want a format in Excel where I can input daily attendance and calculate the salary for the month. Additionally, I need the weekly holidays to be added every month or adjusted when the employee goes on leave.

Thanks,
Karambir

Hello Everyone,

I heard that the limit for ESI has been extended. Previously, it was Rs. 10,000. Can someone confirm this information for me? Has it really been extended?