Hello I need help with some calculations in the attached excel file.
What I am trying to do is to calculate the salaries of personnel depending on the total number of days worked. My problem is with the sheets which carry data for Months which have 31 days. All Salary Calculations are done on 30 day basis irrespective of the number of days in a month. (If there are holidays, salary is still paid for 30 days and similarly if a month has 31 days or 28 days, Salary is paid for 30 days) The attached excel file contains two work sheets - Sheet "June" and Sheet "July" I will try to articulate my problem as: Sheet "July" ---- All calculations seem fine except for Column K, Column M and Column N (Highlighted in Red). Here, the persons have worked for all 31 days of the month. Now using the formula (Monthly Salary * (No. of Days Present / 30)), I get a figure which is more than the persons total salary. Is there any way to resolve this? Thanks in advance... -- Ashish "Of what use is freedom if it does not include the freedom to make mistakes" -- Mahatma Gandhi --~--~---------~--~----~------------~-------~--~----~ ------------------------------------------------------------------------------------- Some important links for excel users: 1. Excel and VBA Tutorials(Video and Text), Free add-ins downloads at http://www.excelitems.com 2. Excel tutorials at http://www.excel-macros.blogspot.com 3. Learn VBA Macros at http://www.vbamacros.blogspot.com 4. Excel Tips and Tricks at http://exceldailytip.blogspot.com To post to this group, send email to excel-macros@googlegroups.com If you find any spam message in the group, please send an email to: Ayush Jain @ jainayus...@gmail.com or Ashish Jain @ 26may.1...@gmail.com ------------------------------------------------------------------------------------- -~----------~----~----~----~------~----~------~--~---
Attendance_Tracker.xls
Description: MS-Excel spreadsheet
