Workday

[lapta301]

I have a date in D1 say 1/11/20 (always 1st of the month) with days of the month that payments are made in A17 downwards and a list of holidays in the range BankHolidays

So with 19 in A22 I would expect to bring 19/11/20 into B22 as it is a workday and is not in the BankHolidays range.

But with 1/12/20 in D1 for the month of December and 25 in A22 as both 25 & 28 are in the BankHolidays range I would expect to bring in 29/12/20

Seems simple enough but I seem to be going round in circles.

As ever your help is appreciated

 

[Fluff]

How about

=WORKDAY($D$1+A22-2,1,BankHolidays)

 

[Dave Patton]

T202010b.xlsm
	A	B
22	25	29-12-20
8b

Cell Formulas
Range	Formula
B22	B22	=WORKDAY(D1+A22-2,1,BankHolidays)

 

[lapta301]

Thank you both it works a treat.

Seems simple when you know the answer I think I was over complicating things in getting to the date.

Again my sincere thanks.

 

[Fluff]

Glad we could help & thanks for the feedback.