Excel Formula for Work Days Calculations: How Do You Use It in Your Projects?

Hi Again all, I am very happy to hear that you all liked the previous attachment.Now see this attachment.i also received this attachment from a CiteHR member. regards, Amarjeet
3rd November 2009 From India, Delhi

Attached Files (Download Requires Membership)

Excel Formula.xls (1.48 MB, 25182 views)

Acknowledge(7)

+2 more

Amend(0)

Add Reply → Start New →

V.Raghunathan

1335

Dear Mr. Amarjeet, a very good Excel file. I sampled a few tips. There is an error in the power calculation "to calculate the area of a circle" given in row 249. The solution given is =P()*(C22,2). It should read =P()*(C24,2).

V. Raghunathan
Navi Mumbai
Regards.
29th January 2013 From India

Acknowledge(0)

Amend(0)

CiteHR is an AI-augmented HR knowledge and collaboration platform, enabling HR professionals to solve real-world challenges, validate decisions, and stay ahead through collective intelligence and machine-enhanced guidance. Join Our Platform.

Other Discussions That May Be Relevant

Excel salary calculation formulas for pf - assistance provided
Hi i am working on salary calculations in excel and facing an issue regarding pf calculation. we have set our basic salary at 6500 for 30 days for employees whose...
5 Replies 1 Files 6 Participants

Enhance your data analysis with a useful excel file download
Dear all i am attaching an excel file that is very useful for both the finance and hr departments. it contains a set of functions commonly used in excel. thank...
16 Replies 5 Files 16 Participants

Comprehensive discussion on payroll calculations and salary calculation methods
Dear hr friends i would like to know about payroll calculations or what the common standards of payroll calculations are. few queries: 1 should it be calculated based on 26...
34 Replies 2 Files 31 Participants

Excel functions for date and time calculations with employee leave calculation
You can add some number of days to a date by simply using the sum function. since excel stores dates as a number of days no further work is required....
2 Replies 0 Files 3 Participants

Exact formula for the attrition rate and employee turnover
Dear all i am a little bit confused about the formulas that are generally used to calculate attrition and employee turnover. kindly reply as soon as possible. regards arpit kansara...
2 Replies 0 Files 3 Participants

What does mean by ncp days for pf software and what is higher flag on epf?
What does "ncp days" mean for pf software and what is the "higher flag" on epf? please help me. vidhya...
40 Replies 0 Files 17 Participants

Re: full function of if formula in excel - xls download
Dear seniors i want a full explanation of the if formula in excel with examples. please help me. thanks...
4 Replies 1 Files 4 Participants

Related Files & Downloads Shared By Members

 56924-ms-excel- manuals-zip-dow nload-excel-for mula.xls

 EXCEL FORMULA.xls

 Excel formula.xls

Excel Formula for Work Days Calculations: How Do You Use It in Your Projects?

Human Resource Management (HRM) Community Journal & KnowledgeBase (Entry: 208333)

TOP ENTRIES ON SUBJECT

Interest Tags

Trending Tags

Trending

Excel Formula for Work Days Calculations: How Do You Use It in Your Projects?

Login Or Register

Human Resource Management (HRM) Community Journal & KnowledgeBase (Entry: 208333)

TOP ENTRIES ON SUBJECT