Find and list missing network days from a column range

[picklefactory]

Hi folks
Can anyone please point me in the direction of how I might go about this? I'm looking for a way to list missing network days from a range of dates. I will have a range of dates in a single column that I want to evaluate. No probs finding total networkdays from start of year to date, and qty of networkdays that are missing, but can I create a detailed list of all missing network days from that range? I'm thinking it might be an array formula, which I rarely do, as they confuse the hell outta me.
Hope that makes sense

 

[Fluff]

What version of Excel are you using?

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

Also can you post some sample data & expected results.

MrExcel has a tool called “XL2BB” that lets you post samples of your data that will allow us to copy/paste it to our Excel spreadsheets, so we can work with the same copy of data that you are. Instructions on using this tool can be found here: XL2BB Add-in

Note that there is also a "Test Here” forum on this board. This is a place where you can test using this tool (or any other posting techniques that you want to test) before trying to use those tools in your actual posts.

 

[picklefactory]

Hi Fluff
I've been on this site so many times over the years, I'd completely forgotten the Excel version was even there. Done and updated Office 2016.
Input data range is a simple column of dates, what I'd like to happen, if at all possible, is to evaluate the column of dates (Col A in sample below) and then in a separate column populate a list of dates that are network days, but are missing from the input range.
Is that a clearer explanation?

I know what I said I meant!!!

DataView220930082643.csv
	A	B	C
1	04/01/2022		20/01/2022
2	05/01/2022		21/01/2022
3	06/01/2022		24/01/2022
4	07/01/2022		25/01/2022
5	10/01/2022		26/01/2022
6	11/01/2022		27/01/2022
7	12/01/2022		28/01/2022
8	13/01/2022		31/01/2022
9	14/01/2022
10	17/01/2022
11	18/01/2022
12	19/01/2022
13	01/02/2022
Sheet1

 

[Fluff]

Thanks for that, how about

Fluff.xlsm
	A	B	C
1	04/01/2022		04/01/2022
2	05/01/2022		20/01/2022
3	06/01/2022		21/01/2022
4	07/01/2022		24/01/2022
5	10/01/2022		25/01/2022
6	11/01/2022		26/01/2022
7	12/01/2022		27/01/2022
8	13/01/2022		28/01/2022
9	14/01/2022		31/01/2022
10	17/01/2022
11	18/01/2022
12	19/01/2022
13	01/02/2022
14
Lists

Cell Formulas
Range	Formula
C1	C1	=MIN(A1:A13)
C2:C11	C2	=IF(C1="","",IF(WORKDAY.INTL(C1,1,1,$A$1:$A$13)>MAX($A$1:$A$13),"",WORKDAY.INTL(C1,1,1,$A$1:$A$13)))

 

[picklefactory]

That looks perfect.... so much for my dumbass assumption of needing an array formula!!!
Brilliant, thank you very much for your time and trouble. I'm glad I asked here for help, as I would never had a clue how to create that formula. I will study it though.

 

[Fluff]

Glad to help & thanks for the feedback.