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

Convert text numbers to real numbers
Select a column containing text numbers. Press Alt+D E F to quickly convert text to numbers. Faster than "Convert to Number"

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
48,216
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,216
Office Version
  1. 365
Platform
  1. Windows
You're welcome & thanks for the feedback
 

Watch MrExcel Video

Forum statistics

Threads
1,114,235
Messages
5,546,649
Members
410,752
Latest member
MC01_
Top