Weekend

P

Pass Codes

I'm trying to schedule a product through up to 4 operations. We do not
operate on Friday, Saturday and Sunday. The product has do be made the day
before it is delivered.

Question; if I have to deliver a product on 06/04/07 (Monday). Is there a
way to calculate the final aoperation to the previous Thursday? It needs to
acknowledge Sunday, Saturday, Friday, and Holidays and schedule the operation
for Thursday.

Thanks in advance

Geo
 
S

ShaneDevenshire

Hi,

You want to use the WORKDAY(StartDate,Days,Holidays) function. To use this
function you must attach the Analysis ToolPak. Tools, Add-in.

Create a range that contains all Fridays and any other Holidays and
highlight that range for the Holidays argument of the function. The Days
argument can be negative.
 
T

Teethless mama

A1: delivery date

=IF(WEEKDAY(WORKDAY(A1,-1,holidays),2)<5,WORKDAY(A1,-1,holidays),WORKDAY(A1,-2,holidays))
 
Top