NETWORKDAYS

Returns the number of whole working days between StartDate and EndDate.

Formula Syntax

NETWORKDAYS(StartDate, EndDate)

StartDate: start date of period.

EndDate: end date of period.

Examples

NETWORKDAYS(DATE(1, 1, YEAR(CALCDATEINPUT)), CALCDATEINPUT) returns the number of days between the start of the year and the entered calculation date.

PensionSoft Corporation | 860.540.3690 | support@pensionsoft.com