Sorry if this is outside of the scope of this forum but I am not aware of where to ask. Trying to help a coworker who is trying to use this code in SharePoint.
=IF(ISBLANK([Start Date]),"",IF(ISBLANK([End Date]),"",IF([Work Schedule]="Part-Time",NETWORKDAYS([Start Date],[End Date])*(4),IF([Work Schedule]="Full-Time",NETWORKDAYS([Start Date],[End Date])*(8),""))))
This returns a syntax error. We have triple checked the names and all are correct. See any other issues?
=IF(ISBLANK([Start Date]),"",IF(ISBLANK([End Date]),"",IF([Work Schedule]="Part-Time",NETWORKDAYS([Start Date],[End Date])*(4),IF([Work Schedule]="Full-Time",NETWORKDAYS([Start Date],[End Date])*(8),""))))
This returns a syntax error. We have triple checked the names and all are correct. See any other issues?