NetworkDays with IF functionality

Austin Probst

Hi,

I am trying to gather a sum total headcount for each day of the month based off another sheet that has a date range of each users visit. How do i capture the total headcount for each day a user is onsite?

I have been using IF(NETWORKDAYS( START DATE, END DATE, = specific day) and get an incorrect argument error.

=IF(NETWORKDAYS({TA Management Submissions Range 3}, {TA Management Submissions Range 2} = [Month_Breakdown]@row))

bisaacs

@Austin Probst Got it

In that case you'll want to use a COUNTIF function to calculate if the Month Breakdown date falls within the Start and End Dates for the listed users:

=COUNTIFS([Start Date]:[Start Date], <=Month_Breakdown@row, [End Date]:[End Date], >=Month_Breakdown@row)

Hope this helps!

bisaacs

Hey @Austin Probst,

So you might be confused as to what NETWORKDAYS does. It returns a number that is calculated by counting the number of business days between two dates, rather than an actual date. You're actually wanting to count how many people were on site on a specific date (Month_Breakdown), correct?

Austin Probst

@bisaacs Yes that is correct. Is there another formula that would better capture this?

bisaacs

@Austin Probst Got it

In that case you'll want to use a COUNTIF function to calculate if the Month Breakdown date falls within the Start and End Dates for the listed users:

=COUNTIFS([Start Date]:[Start Date], <=Month_Breakdown@row, [End Date]:[End Date], >=Month_Breakdown@row)

Hope this helps!