Excel 2007 : Count no. of weekly holidays & government holiday

**dailyglobal** · 07-01-2010, 12:02 PM

Hello every one,
I am very new at this forum and just wondering if I could get a solution. The details of my issue is:

I have start date, finish date and list of holidays. I want to use formula which will show me total no. of holidays within start and finish date for each row.

for example:
Start date
10-Jul

Finish date
24-Jul

Holiday lists
7-Jul
20-jul
23-Jul
25-Jul

no. of holiday
Formula????

How do I formulate?

Looking for you help. Thanks in advance.

Rokon

**masteff** · 07-01-2010, 12:20 PM

So A2 is your start date, A5 is your end date and A8:A11 is your list of holidays:

=NETWORKDAYS(A2,A5)-NETWORKDAYS(A2,A5,A8:A11)

**dailyglobal** · 07-01-2010, 10:52 PM

Perfectly worked. Many many thanks. You have saved the day for me.

Originally Posted by masteff

So A2 is your start date, A5 is your end date and A8:A11 is your list of holidays:

=NETWORKDAYS(A2,A5)-NETWORKDAYS(A2,A5,A8:A11)

**DonkeyOte** · 07-02-2010, 04:07 AM

Another alternative in this context would be:

=COUNTIFS(A8:A11,">="&A2,A8:A11,"<="&A5)

**masteff** · 07-02-2010, 05:45 PM

Originally Posted by DonkeyOte

Another alternative in this context would be:

=COUNTIFS(A8:A11,">="&A2,A8:A11,"<="&A5)

Cool. I really do need to move up to Excel 2007.

**DonkeyOte** · 07-02-2010, 06:39 PM

I think general consensus would be to skip 2007 and move straight to 2010 which is regarded as a fairly big improvement.

Office 2007 is it seems to be seen in similar terms to the Millennium Edition OS of old ... ie not to be spoken of and surpassed (significantly) by follow up (XP)