insert date + 2,

Trevor3007

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

Spell Check in Excel
Press F7 to start spell check in Excel. Be careful, by default, Excel does not check Capitalized Werds (whoops)

Fluff

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

Trevor3007

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

saved me a lot of work too :}

KR
Trevor3007
 

Fluff

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

Watch MrExcel Video

Forum statistics

Threads
1,109,455
Messages
5,528,879
Members
409,844
Latest member
ardask
Top