working with dates ignoring weekends & UK bank holidays


Posted by Phil on July 30, 2001 10:13 AM

I want to get Excel to work with 2 dates and tell me how many working days (i.e. not a weekend or UK bank holiday) there are between the two dates. 30 July minus 26 July should give me 2 days and not 4.

Can anyone help?

Posted by Aladin Akyurek on July 30, 2001 10:31 AM

=NETWORKDAYS(A1,B1,HOLIDAYS)

where A1 and B1 are dates of interest (with B1>A1) and HOLIDAYS the range that contains the date for UK bank holiday and other holidays.

You have to activate Analysis Toolpak (via Tools|Add-ins) in order to use this function.

Aladin



Posted by Judy on September 10, 2001 5:48 AM


HOW/WHERE DO YOU DEFINE THE HOLIDAYS YOU WANT TO EXCLUDE? THANKS!