Formula Unparsable

Trym Dahl

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

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å

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, andree@getdone.se)

Have a fantastic day!

Best,

Andrée Starå

Workflow Consultant @ Get Done Consulting

Andrée Starå

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

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