easy udf by VB
 

happy new year,

In one sheet, i have a column list of holiday date list . The dates are
populated by formulas and other udf. (Col.A="description" ;
Column.B="holidays")

I need to make another column list of networking days which will include the
dates from the holiday list AND those days that are to be search based on the
following guideline parameters for extra non-working day.

1. there is no work if the day is between two holidays .

2. there is no work if the day is between a holiday and sunday.(e.g.
31-Dec-2007)

3. if a holiday falls on Sunday, there is no work on the following day (mon).
Note. there is a Work on monday after easter sunday.
In Col.A. the holiday easter sunday has a description as "EASTER"

hope this make sense...

happy holidays
4pinoy

easy udf by VB
 

please add this line i forgot,
"""6 workdays per week : from monday to saturday''''


"been dribbled to 2007" wrote:

happy new year,

In one sheet, i have a column list of holiday date list . The dates are
populated by formulas and other udf. (Col.A="description" ;
Column.B="holidays")

I need to make another column list of networking days which will include the
dates from the holiday list AND those days that are to be search based on the
following guideline parameters for extra non-working day.

1. there is no work if the day is between two holidays .

2. there is no work if the day is between a holiday and sunday.(e.g.
31-Dec-2007)

3. if a holiday falls on Sunday, there is no work on the following day (mon).
Note. there is a Work on monday after easter sunday.
In Col.A. the holiday easter sunday has a description as "EASTER"

hope this make sense...

happy holidays
4pinoy