User Function.

[Paulo]

hi,
50% of by hair loss this year is due to problems with Analyst tool pack.
syncing with excel on several computers

i came up with whis formula in excel
where FERIADOS = array of dates
=SE(F6>0;SE(OU(DIA.DA.SEMANA(F6)=7;DIA.DA.SEMANA(F6)=1;ÉNÚM(CORRESP(F6;FERIADOS;0)));workday((F6);2;FERIADOS);workday((F6);1;FERIADOS));0)
translating
=IF(F6>0;IF(OR(WEEKDAY(F6)=7;WEEKDAY(F6)=1;ISNUMBER(MACH(F6;FERIADOS;0)));workday((F6);2;FERIADOS);workday((F6);1;FERIADOS));0)

I would like some help on making it in VBA without needing Analyst tool pack

so the logic's of this
F6 = date
1) if F6 is Saturday, TRUE
2) if F6 is Sunday, TRUE
3) If 6 belongs to Holiday array, TRUE

if true then
date + 2 days skipping holidays
else
date + 1 days skipping holidays

my biggest problem is what the "workday" formula, do

any help is appreciate

 

[Paulo]

thank you katie,
I will take a look @ it.