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?

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" <(E-Mail Removed)> wrote in message
news:045E4AF4-392C-459E-BD3D-(E-Mail Removed)...
>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?

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" <(E-Mail Removed)> wrote in message
> news:045E4AF4-392C-459E-BD3D-(E-Mail Removed)...
> >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?
>
>