Hi
I have searched forums but to no avail at the moment.
I am trying to have a formula that will show the date for a mailing to be sent out. Normally the day in is day out unless it is a Saturday or Sunday when it will be Monday. So far so good. Problem is if the day is a bank holiday eg Good Friday. My formula still sends out the same day. I need it to go to the Tuesday, ie day after Easter Mondya. Formula is as follows - "holidays" is the array with holiday dates in. thank you in advance
Dave
=IF(ISBLANK(E200),"",IF(WEEKDAY(E200,2)<6,E200,WORKDAY(E200,1,holidays)))
E200 is date received.
Bookmarks