Formula Unparsable

Trym Dahl · 04/03/19

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)

Midnight2400 · 04/03/19

It looks like you used semicolons instead of commas. I also used the today function instead of refrencing a cell.

Try this:

=IF(AND(TODAY() > [Start 2020]2, TODAY() < [End2020]2), NETWORKDAYS([Start 2020]2, [End2020]2) - [Passed Days 2020]2, [Workdays minus vacancy 2020]2)

Andrée Starå · 04/04/19

Hi Trym,

Can you describe your process in more detail and maybe share the sheet(s) or some screenshots? (Delete/replace any confidential/sensitive information before sharing) That would make it easier to help. (share too, [email protected])

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Andrée Starå · 04/04/19

Midnight2400,

I think Trym is in an area where semicolons are used instead of commas, so that's probably correct.

Best,

Andrée

Paul Newcome · 04/05/19

My best recommendation would be to check your column names to make sure they are correct.

Formula Unparsable

Comments

Help Article Resources

Categories