Formula to Count Working Days

Joecam

Member
Joined
May 22, 2014
Messages
41
Reaction score
0
Points
6
Excel Version(s)
365
Hello!

I'm trying to write a formula that I can copy & paste into a spreadsheet every day to let me know how many working days certain tasks have sat in a queue. I have a date column and basically all I need to do is count that column where any dates which fall on a weekend counting towards the following Monday. The format can be flexible and helper cells are fine, but what I'm having trouble with is making it work with a limited amount of editing. Just now I'm just using a COUNTA formula, but it's still a good amount of manual work due to the size of the column.

Pivot tables are not an option unfortunately. Any help would be greatly appreciated!
 
Please post a small sample sheet ( Go advanced - Manage attachments) with some data and expected results. Thx
 
Back
Top