can be done..first check if the month is for 28,29,30 or 31 days..
can be done using if statement.
then simply apply the formula..
or u want detailed solution...
7th June 2010 From India, Hyderabad
AM IN IT COMPANY. I WANT TO KNOW HOW MANY DAYS WE WANT TO CONSIDER FOR SALARY. WHETHER 30/31 OR 26(EXCLUDING 4 SUNDAYS) OR 22 (EXCL SAT & SUN).DAYS. FOR EX. mr.A getting salary for Rs.15000 for dec 2010.
for this how we calculate and any1 can send me some excel formats to my mail id
28th December 2010 From India, Hyderabad
I am an HR Freelancer, Call me on 9820233738. Can help you with all necessary format, to make your work easy on best cost possible.
My Profile is as below:
Organizational Design And Structuring
HR Development (Planning, Communication, And Analyzing)
Job Profiling, Manpower Planning, Recruitment And Hiring
Compensation, Rewards, And Benefits Management
Time Office Attendance & Leave Records Management
Payroll Management, CTC, Bonus, Leave Encashment, Full And Final And TDS Calculation.
Creating HR & Administrative Policy, Organization & System Designed.
Guide To Create Positive Work Environment To Achieve Organizational Vision.
MIS Management & Analyzes
KRA & Goal Setting
28th December 2010 From India, Mumbai
form earned salary to break up which includes basic, da and othere allowances
if any lop exists salary varies from gross to earned
make the statutory deductions from earned salary
some times you may consider gross salary for some statutory deductions. so, be cautious.
be versed with excel formulas like if statement.
hope your question is answered
8th January 2011 From India, Warangal