insert date + 2,

[Trevor3007]

hi,

I have a date in A2 & if C2 = Yes, then D2 = A2 + 1, however the date in D2 must not be a weekend .

Example

A2 = 22/3/19 , C2 = Yes then D2 would return 25/3/19 etc. The full range is A2:K200


Can some kind person solve for me?

MTIA
KR
Trevor 3007

 

[Fluff]

How about
=IF(C2="Yes",WORKDAY(A2,1),"")

 

[Trevor3007]

thanks... seems to work a treat.

saved me a lot of work too :}

KR
Trevor3007

 

[Fluff]

You're welcome & thanks for the feedback

 

[Trevor3007]

NP & justly deserved.