List working dates between two dates

[AndyMb]

Hi,

I want to list sequentially all working dates between two dates inclusively.

So in A1 I have start date and A2 end date.

In B1 would be the first working date, B2 the second working date and so on until it reached the end date.

example.

Start: 22nd December 2017
End: 28th December 2017

There are 3 working days and would be listed in column B as:

22/12/17
27/10/17
28/10/17

So the weekend (23rd and 24th would be ignored and Christmas Day and Boxing day would be ignored) note : I have a table of holiday dates (Christmas etc.)

Any thoughts?

Thanks

 

[FormR]

Hi, here is one option - in this example the holiday dates list is D1:D2.. formula in B1 is copied down.

Excel 2013/2016
	A	B	C	D
1	22-Dec-17	22-Dec-17		25/12/2017
2	28-Dec-17	27-Dec-17		26/12/2017
3		28-Dec-17
ALL input datatable

Cell Formulas
Range	Formula
B1	=IF(ROWS(B$1:B1)>NETWORKDAYS($A$1,$A$2,$D$1:$D$2),"",WORKDAY($A$1-1,ROWS(B$1:B1),$D$1:$D$2))

 

[AndyMb]

FormR, that works perfectly thank you and thank you for your quick reply.