Ad-Free CAclubindia and Daily Updates on your mobile. Subscribe Now!

Salary Calculation

sachin patil (Accountant) (102 Points)

04 March 2009

Hello. i am working with construction company engaged in dam work. In our company lots of people working for a season starts from Sepember upto June of next year. in this time we pay only advance to them. and after the end of season we done all salary calculations & pay balance after deducting the advance. i require a file which help me to calculate the salary for 6 or 7 seven month. please help me

Reply
Follow
Share

5 Replies

sachin patil (Accountant) (102 Points)
Replied 04 March 2009

how to calculate days in excel

Upgrade to CAclubindia Pro. Subscribe Now!

RUPOM SHARMA (Professional) (28 Points)
Replied 04 March 2009

Hi Sachin!

To calculate number of days in excel you type the two dates first. Be sure to choose the format of date first from -Format-Date. Click in the cell where you want to have the answer. Click the "Insert" button, select "function" and in the 'or select a catagory' select 'date'. Then the same window go to 'select function' and choose 'DAYS360'. Guess rest you can manage.