You are viewing limited content. For full access, please sign in.

Question

Question

NETWORKDAYS excluding weekends and holidays

asked on April 19, 2016 Show version history

Hello, i want to calculate "networkdays", but excluding weekends and holidays.  

I am creating holidays in workflow administration console, but workflow is not taking it into account.

 

0 0

Answer

SELECTED ANSWER
replied on April 20, 2016

To get around it, you can make a separate workflow to calculate networkdays. Enter the holidays into a multi-value date token and then update them annually.


Of course if you're looking to do calculations out longer than a year this all falls down.

 

 

 

 

1 0
replied on April 20, 2016

Thank you Carl!

Excellent idea.

0 0

Replies

replied on April 19, 2016

This is a known issue. We don't currently a fix.

1 0
replied on April 20, 2016 Show version history

Hey Miruna,  I thought I was the only one using (Exclude weekend and Holiday).  I'm happy to see there are other requesting it.  smiley

Hope this calculation can be in WF V11 and that this calculation can be also available in Forms.

Regards,

1 0
replied on March 22, 2018

You could have a Laserfiche form that is assigned annually to update the holidays which would go to workflow and solve the issue for non-technical users having to update them.

0 0
You are not allowed to follow up in this post.

Sign in to reply to this post.