accounting (different) State holidays

  • Thread starter Thread starter Rajkumar1
  • Start date Start date
R

Rajkumar1

This is a call to the quintessence - the fifth and highest source o
intelegence known to mankind (the WWW)

I work with performance reporting, the performance of an activity i
calculated by comparing the actual (number of days) with the agree
days for the activity

I use NETWORKING DAYS and can get the result.

But now I am going NATIONAL and the holidays in each state i
different, so I am not able to use the NETWORKING DAYS (with holidays
to meet my requirement

Can you please assist?

Thanks and regards,
Ra
 
This may not fit your data, but....

I created a holiday list for each state (actually, I used 2!).

I gave each holiday list a nice range name (like: ST_Holidays)
So I had IL_Holidays, Wi_holidays, Tx_Holidays, ...

Then my data was set up so that I had my dates and my state on each row.

I had the state in column A and the two dates in B1:C1.

Then in D1, I used this formula:
=NETWORKDAYS(B1,C1,INDIRECT(A1&"_Holidays"))

With IL in A1, that was equivalent to:
=NETWORKDAYS(B1,C1,IL_holidays)

But when I dragged it down, it used that state abbreviation in column A for each
row.
 
Back
Top