How to calculate staff salary with absent days

To calculate salary with absent days, divide the monthly salary by the number of days you count in a month. This gives you the salary for one day. Then multiply it by the days the person was present. Paid weekly offs and paid holidays count as present.

That is the whole method. Below you will find the formula, worked examples with real numbers, and answers to the questions shop owners ask most: 26 or 30 days, half days, late marks, salary advances and staff who join in the middle of the month.

The simple formula

Salary to pay = (Monthly salary ÷ Days in the month) × Days present

Or, if you prefer to think in cuts:

Salary to pay = Monthly salary − (Salary for one day × Absent days)

Both lines give the same answer. Use whichever is easier for you.

Step by step

1. Fix your “days in the month”. Choose 30, 26 or the actual number of days in the month (more on this below). Use the same choice every month.
2. Find the salary for one day. Monthly salary ÷ days in the month.
3. Count the days present. Days in the month minus absent days. Count a half day as 0.5.
4. Multiply. Salary for one day × days present.
5. Subtract any salary advance the person took during the month.

Worked example

Ramesh works in a kirana store. His salary is ₹12,000 a month. This month (30 days) he was absent for 3 days.

So Ramesh gets ₹10,800. The cut for 3 absent days is ₹1,200.

Divide by 30, 26 or the actual days?

There is no single rule for every shop, and shop owners use all three methods. What matters is that you choose one, tell your staff before the month starts, and use it every month. Here is how the same case (₹12,000 salary, 3 days absent) works out:

• 30 days is the easiest. The salary for one day is the same every month.
• 26 days is common when Sunday is a paid weekly off. You count only working days, so each absent day costs a little more.
• Actual days is the most exact, but the salary for one day changes every month (28, 29, 30 or 31 days).

One rule always applies: the cut should be in proportion to the days missed. Never cut more than the absent days are worth. If you are unsure about the rules in your state, check with your accountant.

Half days and late marks

Count a half day as 0.5. If Ramesh was absent 2 full days and took 1 half day in a 30-day month, he was present for 27.5 days: ₹400 × 27.5 = ₹11,000.

For late marks, decide a rule in advance and write it down, for example “3 late marks = 1 half day cut”. Staff accept a rule that was fixed before the month started. They argue about a rule made up on salary day.

Weekly offs, holidays and paid leave

A paid weekly off, a paid festival holiday or paid leave is not an absent day. Count it as present. Only cut salary for days that are unpaid: the person did not come and had no leave left.

Make a simple holiday list at the start of the year (for example Republic Day, Independence Day, Diwali and your local festivals) and share it with your staff. Then nobody argues about which days were paid.

Salary advance

If a worker took an advance during the month, subtract it after you work out the salary. Ramesh’s salary was ₹10,800 and he took a ₹2,000 advance, so you pay him ₹8,800. Write down every advance with the date and amount, and show the worker the cut on his salary slip.

Joined in the middle of the month

Pay only for the days from the joining date. If a new worker on ₹12,000 joins on the 11th of a 30-day month, she works 20 days: ₹400 × 20 = ₹8,000. Do the same when someone leaves in the middle of the month.

Daily wage staff

For staff paid by the day, it is even simpler: daily wage × days worked. A helper on ₹500 a day who worked 24 days gets ₹500 × 24 = ₹12,000. Count half days as half the daily wage.

Mistakes to avoid

• Changing the formula from 30 to 26 days (or back) in the middle of the year without telling staff.
• Cutting salary for a paid weekly off or a paid holiday.
• Forgetting to subtract the salary advance, or subtracting it twice.
• Rounding the salary for one day too early. Round only the final salary to the nearest rupee.
• Keeping attendance in memory or on loose paper. One lost page means arguments at month end.

Let the app do it for you

With Attendance Genie Lite you mark attendance on your phone every day: present, half day or absent. At month end, the app counts the days, cuts absent days and salary advances, and gives you every worker’s salary. No maths, no register. It is free for up to 3 staff. See the plans or start free.

Frequently asked questions