How to calculate number of working days excel 2003?

[Kunal]

Hi

I want to know how to calculate number of working days in excel 2003.

Saturday and Sunday should be skipped during counting of days.


-Kunal Saxena

 

[Hui]

Kunal


Try using Networkdays


eg =+NETWORKDAYS(B5,L5)


B5 - Start Date

L15 - End Date

Note that it includes both the start and end dates in the days counted

you can also add your own public holidays if you need

 

[FilC]

Can anyone help me to add in holiday dates to this calculation please?

 

[Hui]

Filc

The format is

=+NETWORKDAYS(Start date, End Date, Other Holidays)

so a typical usage is

=+NETWORKDAYS(B5,AA5,{"4/1/2010","6/1/2010"})

Note the use of { and " in setting up an array of dates separated by commas

 

[FilC]

Hui

Many thanks. Does that mean I dont have to set up a list? Does the comma indicate a range of dates, i.e 4 to 6 January?

 

[Hui]

You will have to setup a list of Public and other Holidays

The , is not a range, the array is a list of individual dates

It is probably limited at about 250 characters, which should be plenty for your needs

You can't have the dates in another cell, but you can use a Named Range to store the dates


so =+NETWORKDAYS(B5,AA5,PHolidays)


is valid if you have a Named Range PHolidays which is equal to ={"4/1/2010","6/1/2010"}