insert date + 2,

Trevor3007

Well-known Member
Joined
Jan 26, 2017
Messages
515
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
 

Some videos you may like

Excel Facts

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
48,400
Office Version
  1. 365
Platform
  1. Windows
How about
=IF(C2="Yes",WORKDAY(A2,1),"")
 

Trevor3007

Well-known Member
Joined
Jan 26, 2017
Messages
515
thanks... seems to work a treat.

saved me a lot of work too :}

KR
Trevor3007
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
48,400
Office Version
  1. 365
Platform
  1. Windows
You're welcome & thanks for the feedback
 

Watch MrExcel Video

Forum statistics

Threads
1,114,470
Messages
5,548,207
Members
410,824
Latest member
Bobmn4
Top