picklefactory
Well-known Member
- Joined
- Jan 28, 2005
- Messages
- 506
- Office Version
- 365
- Platform
- Windows
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
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