Counting the date range inside/between two columns?

OlliR

Thank you for a super fast reply Andrée :)

Working days would be better, but it really does not matter that much, if the calculation returns a sane result :)

OlliR

Sorry, somehow made a double post.

Andrée Starå

@OlliR

Try this.

=NETWORKDAYS(MIN(COLLECT(Start:Start, [PK/Siivous]:[PK/Siivous], "Siivous")), MAX(COLLECT(Finish:Finish, [PK/Siivous]:[PK/Siivous], "Siivous")))

Would that work?

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!

OlliR

Hi Andrée, thank you one again :) I get the same result, e.g. it does not take into account all the rows - seems to somehow randomly calculate the other rows than the first one. I wonder if the problem is there not being any cell range? How would the syntax go with e.g. rows 3-12?

Andrée Starå

@OlliR

Can you share the sheet with me so I can take a look?

OlliR

Unfortunatey I cannot, our Company settings won't let me share the sheet - not at least as a SmartSheet. As an exported Excel/Google sheet it is possible, though.

Andrée Starå

@OlliR

Please share the Excel sheet with screenshots of the Smartsheet sheet.

Share to andree@workbold.com

OlliR

Hi Andrée, had a short weekend trip, wasn't able to post earler. I'll share an Excel sheet, I'll send you the link via private message 👍

OlliR

Hi Andrée, did you get the Excel sheet, I sent to you via email? :)

OlliR

Got it working :) There's something fishy with the COLLECT, so I just left that out. Now it seems to calculate the NETWORKDAYS correctly 👍

Andrée Starå

@OlliR

Excellent!

Glad you got it working!

✅Remember! Did my post(s) help or answer your question or solve your problem? Please support the Community by marking it Insightful/Vote Up/Awesome or/and as the accepted answer. It will make it easier for others to find a solution or help to answer!