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
Menu
Salary Calculation
Replies (5)
how to calculate days in excel
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.
thanx rupom. but this count as 360 days in year. which is not suitable for me. I found another formula which helps me lot i.e. "datedif"
Hello Rajesh, please explain with forumula. Start Date is 1/1/2009 & end Date is 1/6/2009. then how it work.
Recent Threads
- TDS on purchase of property more than 50 lakhs
- Withdrawal from post NSS
- Section 10(11) or 10(12) of exempted income
- New income tax act
- Duplication of Interest on SCSS deposits in postof
- Declaration of foreign investment
- Parent buying property for major child
- LIC maturity amount filing missed
- Advice on income tax
- E filing thr net banking for AY2025-26
Related Threads
CAclubindia
