How use Excel networkdays

[Croulet]

Hi,
I had Microsoft Office 2003 installed in my system. I am creating a small project in Microsoft Excel. I that I had to calculate a number of holiday granted to any employee in a month. I tried some other functions but did not get that result which I want. I now about Excel networkdays but don't know to use it. I need a complete steps to apply it in table and get the wanted results. Thanks in advance.

[Macarenas]

First to use networkdays you will need Analysis ToolPak. If it is not there then you cannot use the functions. To add go to tools menu. Select Add-ins. In the Add-in box select Analysis ToolPak. Click OK. Now Go to tools Data Analysis. In the box select Random Number Generation. Now the Analysis ToolPak is enabled in your system. Whenever your use networkdays function to calculate multiple holidays, always enclose the dates in braces ({..}). It is a function which returns the number of all working days between the two dates. It can be excluded by using the holidays parameter. Just by entering starting and ending dates by using the DATEVALUE as numbers you get your results. The DATEVALUE function identifies dates from the sheet. Lets take a small example

[ThoMas321]

You can activate the networkdays process by going to add in from tools menu and select Analysis Toolpack. By this function you get days between two corresponding dates. The function by which you can determine the holidays is - NETWORKDAYS(start_date,end_date,holidays). The start date denotes the date function of the beginning date which includes date, month and year. The below example will explain you in more details : -

A1: 24/12/92
C1: 25/12/92

Then, type the following formula in cell D1:

=NETWORKDAYS(DATEVALUE("1/1/92"),DATEVALUE("31/12/92"),{A1,C1})

[chroma]

I am providing you a complete steps to use the networkdays functions. If the syntax is proper then you can get desirable results. The syntax is - networkdays(start_date, end_date[, holidays]). The start date is the beginning one and the end date is the last one of the data range. Ms Excel normally stores data internally as positive numbers. The numbers indicates the starting and ending of dates. Now in the syntax enter the beginning date in start_date and the last date in end_date. Refer the examples below : -

=NETWORKDAYS(DATE("2008,10,1"),DATE("2009,1,22"),A2:A4) returns 105. There are 105 weekdays between October 1, 2008, and January 22, 2009, not counting the holidays entered as 11/26/2008, 12/4/2008 and 1/21/2009.