Formula Unparsable

Trym Dahl
Trym Dahl
edited 12/09/19 in Formulas and Functions

Hi there,

Trying to return the amount of workdays between two dates if the today-date is during that same year, else return a "standard value" but im getting an error, anyone with better formula skills who could help me fix this?

=IF(AND(Today2 >[Start 2020]2; Today2 < [End2020]2); NETWORKDAYS([Start 2020]2; [End 2020]2) - [Passed days 2020]2; [Workdays minus vacancy 2020]2)



Help Article Resources

Want to practice working with formulas directly in Smartsheet?

Check out the Formula Handbook template!