How to calculate per day salary in excel

To know the per day salary divide your salary by the total number of days in a month, and to know the monthly salary multiply the per day salary by the total number of paid days in a month. 

Salary per day = Salary / Total Days in a Month

For example, if your salary is 30,000 Rs 

and the number of days in a month is 30 days then your per day salary = 30000/30= 1000 Rs

If the number of days is 31 days then per day salary = 30000/31= 967 Rs

If the number of days is 28 days then per day salary = 30000/28= 1071 Rs

The above calculation is not only used to calculate your gross salary per day, using the same formula you can calculate your per day allowances as well. 

For example, if your conveyance allowance per month is 1600 Rs and the of days in that month is 30 days.

Then per day conveyance allowance = 1600/30 = 53 Rs.

Per Day Salary Calculation in Excel

Download Excel Format

How to calculate monthly Salary 

Monthly salary = Per day Salary X Total Paid days

Per day salary = Salary / Total days in a month

Paid days = Total days in a mo