Date ranges
 

I have 2 sets of date ranges:
1) a list of statutory holiday dates for the current year (ie boxing day,
Easter, etc)
2) a list of 52 weeks for the current year with only Saturday and Friday
dates that represent the start and end date of billing weeks (for example,
Sat Jan 6 and Friday Jan 12 for week 1, Sat Jan 13 and Fri Jan 19 for week 2
and so on).

I would like to be able to count the number of business days per week - but
in order to do this accurately I need to know which weeks have a stat
holidays so that the stat holiday will not count as a business day.

I tried using variations of vlookup, but I don't this this will work.

Any ideas?

Date ranges
 

Look into using the NETWORKDAYS function... it does exactly what you want.
It requires the Analysis ToolPak add-in to be added to your copy of Excel
(via Tools/AddIn on Excel's menu).

Rick


"MLK" wrote in message
...
I have 2 sets of date ranges:
1) a list of statutory holiday dates for the current year (ie boxing day,
Easter, etc)
2) a list of 52 weeks for the current year with only Saturday and Friday
dates that represent the start and end date of billing weeks (for
example,
Sat Jan 6 and Friday Jan 12 for week 1, Sat Jan 13 and Fri Jan 19 for week
2
and so on).

I would like to be able to count the number of business days per week -
but
in order to do this accurately I need to know which weeks have a stat
holidays so that the stat holiday will not count as a business day.

I tried using variations of vlookup, but I don't this this will work.

Any ideas?

Date ranges
 

Works like a charm! Thank you very much for your help.
Mary-Lou

"Rick Rothstein (MVP - VB)" wrote:

Look into using the NETWORKDAYS function... it does exactly what you want.
It requires the Analysis ToolPak add-in to be added to your copy of Excel
(via Tools/AddIn on Excel's menu).

Rick


"MLK" wrote in message
...
I have 2 sets of date ranges:
1) a list of statutory holiday dates for the current year (ie boxing day,
Easter, etc)
2) a list of 52 weeks for the current year with only Saturday and Friday
dates that represent the start and end date of billing weeks (for
example,
Sat Jan 6 and Friday Jan 12 for week 1, Sat Jan 13 and Fri Jan 19 for week
2
and so on).

I would like to be able to count the number of business days per week -
but
in order to do this accurately I need to know which weeks have a stat
holidays so that the stat holiday will not count as a business day.

I tried using variations of vlookup, but I don't this this will work.

Any ideas?