6 Replies Latest reply: Jul 29, 2015 4:34 AM by Andy Weir

# How to calculate specific networkdays

Hello All, I am using the following formula to calculate network days between two months and it works for consecutive months

networkdays(min("End Date"),max("End Date"))

HOWEVER

Let's say...If I select January, February and March, the calculation will be OK

If I select only January and March, the calculation WILL include the days from February which I don't want.

Semester 1 2015=129 network days

Q1 2015=64 network days

Jan and Mar 2015=44 days HOWEVER it counts the 20 from Feb

Any ideas on how to solve this? What other formula could I use?

Jose

• ###### Re: How to calculate specific networkdays
 End Date 2/1/2015 1:23:00 AM 2/1/2015 2:07:00 AM 2/1/2015 2:23:00 AM 2/1/2015 8:01:00 AM 6/30/2015 6:58:00 PM
 6/30/2015 7:55:00 PM 6/30/2015 8:01:00 PM 6/30/2015 8:02:00 PM
• ###### Re: How to calculate specific networkdays

how are you only getting Jan and March data ?

you should include Feb as part of the holidays parameter

• ###### Re: How to calculate specific networkdays

Please provide proper sample data or file..

I believe that NetWorkDays function is not your friend in this scenario.

You need to work on script to calculated number of days per month similar to NetWorkDays.... But better if you can provide an excel file with proper End Dates along with some sample showing your selection and result you expecting.

• ###### Re: How to calculate specific networkdays

As a work around could you create a master calendar and add NetworkDays as a field in it.  You could populate the values in the load or in the data source for your calendar.  So when you select a month you sum the network days of the month selected.

Regards

Andy