If Friday

[dan123dan321]

I am trying to build and If statement to adjst for weekends. Currently I have

Start Date Cell D501-Jan-13
End Date Cell D601-May-14

Cell D8=D5
Cell C8=D2
Cell D9=IFERROR(IF(C8="Friday",IF(D8+2>$D$6," ",D8+2),IF(D8+1>$D$6," ",D8+1))," ")

In Cell C8 the format is dddd so it shows the day of the week

What I am trying to do is skip to Monday if a friday though I am also concious of holidays falling on weekdays too and not sure how to acount for this.

Any ideas anyone?

Dan

[nathansav]

Is WORKDAY any good?

[dan123dan321]

I have been trying to factor in work day to the function because it would / should account for what I am trying to do but I'm not sure how to incorporate it with my Start Date / End Date

[gak67]

Rather than IF(C8="Friday" would IF(WEEKDAY(C8,1)=6 work?

[dan123dan321]

It might but I'm not sure how to adjust the logic of the function to skip to the next working day?

[gak67]

Please Login or Register  to view this content.

Holidays is a named range where you list the holidays in that period.