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 :
- Query - Section 164(2)(a) – Interpretation o
- Submission for Expert Opinion on Rectification of
- NRI since March 2023 – resident savings acco
- My All-Time Top 15 Indian Web Series
- Wrong date of invoice
- Paper 6 - IBS
- Chhath Puja 2026 Dates Timing Tithi
- Tax Benefit on Second Property
- IPO application checklist: 18 rules that decide wh
- NSE IPO Price, GMP, Allotment Date and Listing
Related Topics :
CAclubindia
