NETWORKDAYS

Returns the number of working days (Monday–Friday) between two dates. Essential for SLA tracking and schedule calculations.

Syntax

smartsheet-mastery

=NETWORKDAYS(start_date, end_date)

Example

smartsheet-mastery

=NETWORKDAYS([Start Date]@row, [End Date]@row)
=NETWORKDAYS([Created Date]@row, TODAY())   // Days open so far
=IF(NETWORKDAYS([Created Date]@row, TODAY()) > 3, "SLA Breach", "Within SLA")