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"
DAY(DATE(YEAR(D3),MONTH(D3)+1,1)-1)
Use this formula to calculate exact date
>> Rajesh
Hello Rajesh, please explain with forumula. Start Date is 1/1/2009 & end Date is 1/6/2009. then how it work.
Recent Topics :
- CAN PARTNERSHIP FIRM SIGN SERVICE AGGREMENT WITH A
- E-waybill
- Sell of CAFC books
- ITC ON RENT
- GSTR-9 Table 8A Portal and Excel Issues
- IGST on Commercial Rental Income (Different State)
- Revocation of suo moto cancelled GST registration
- Is there any faculty taking chapterwise test in CA
- Late Fees and Interest
- HDFC Bank’s Bureaucracy: The Nightmare of Fl
Related Topics :
CAclubindia
