How to calculate specific networkdays

[#1]

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?

Thanks in advance!

Jose

[sasiparupudi1]

Please post sample data

[#3]

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

[ramoncova06]

how are you only getting Jan and March data ?

you should include Feb as part of the holidays parameter

[#5]

any ideas please? kunalbhattacharjee91‌ MRKachhiaIMP‌

[MK_QSL]

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.

[ogster1974]

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