Count Down the Remaining Working Days

@Kal

The syntax for NETWORKDAYS is NETWORKDAYS(start_date, end_date, [ holidays ])

=NETWORKDAYS(TODAY(0), [Q3 End]@row)

Keep in mind a few things:

The TODAY function only updates its value if the sheet is opened or rows are otherwise modified in some way. Because of this, you may want to add a helper column called CurrentDate, and use scheduled automation at 1am each morning to record the date in that field. Then use =NETWORKDAYS([CurrentDate]@row, [Q3 End]@row) instead of TODAY(0).

Also, with this formula in place, once we're past the [Q3 End]@row date, the value in this formula cell will start counting negative. If you don't want that, you might consider an IF statement as part of the formula:

=IF([CurrentDate]@row <= [Q3 End]@row, NETWORKDAYS([CurrentDate]@row, [Q3 End]@row), 0)

In English, if the current date is less than the Q3 End date, count the networkdays from current date to Q3 End date, otherwise, set this cell to 0 (or whatever alternate value you'd want there.)