Perhaps off topic but need sytax error help

[TWTHOMAS]

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?

 

[6StringJazzer]

Can you show a sample of what table looks like? Headings row and one row of data would be enough.

EDIT: Never mind, see next post.

 

[6StringJazzer]

Your formula works fine for me as long as it is in the table.

$scratch.xlsm
	A	B	C	D
1	Start Date	End Date	Work Schedule	Formula
2	8/23/2023	9/1/2023	Part-Time	32
table syntax

Cell Formulas
Range	Formula
D2	D2	=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),""))))

If you want to use it outside the table, your structured references have to be qualified with the table name like this:

=IF(ISBLANK(Table1[@[Start Date]]),""