Skip to main content

calculate a working day between two dates

I would like to ask for a help. I need a to calculate a working day between two dates. Is there a function or a combination functions that can do this?
Thanks a lot.

Brian Element Wed, 03/08/2023 - 09:38

If you download the custom function package from passport there is a custom function that will do this.  You will need V12 of idea to use this.

ElaP Tue, 07/09/2024 - 03:53

In reply to by Brian Element

Hi Brian
I now have IDEA v12, where and how can I download the Networkday function from? I have a function called Workday, but this function only indicates the day of the week of a given date. I need the difference in working days between two dates.
Thanks a lot.

Brian Element Tue, 07/09/2024 - 06:29

In reply to by ElaP

Hi Elap,

If you go into Passport you can download and install the file.  To access passport open IDEA and under the Home tab select Passport.  You will need a username and password to access this.  From Passport select the IDEA Lab tab and then select Custom Functions.  Download the Custom Functions and install them, they are contained within an exe file that will install them within your local library.  You should then have access to them from within the Equation Editor.