Helo with formula Please :)

[deletedalien]

so i have this formula (not VBA)

=IF(D2="","",IF(MONTH(IF(WEEKDAY(D2,2)=5,D2+3,D2+1))<>MONTH($D$2),"",IF(WEEKDAY(D2,2)=5,D2+3,D2+1)))

which just looks for the next workday in the current month (excludes weekends)

BUT it currently does not ignore my "holiday" named range,

how can i get it to do so?

'Thanks for your help

 

[Jonmo1]

Try

=IF(MONTH(WORKDAY(D2,1,A1:A20))<>MONTH(D2),"",WORKDAY(D2,1,A1:A20))

A1:A20 holds your holiday dates.

This requires the analysis toolpack from Tools - Addins

 

[deletedalien]

AWESOMENESS
is a virtue amongst the people in this forum


THANK YOU!!!!!!!!

Worked Better than perfect!

 

[Jonmo1]

Glad to help, thanks for the feedback.