Network Days

[varunreddy]

Hi Guys,

Can anyone correct the syntax?

networkdays(date#([As of Date],'MM-DD-YYYY'), date#([Creation Date],'MM-DD-YYYY'))

Thanks in advance!

Regards,

Varun

[MK_QSL]

Are you getting syntax error?

[varunreddy]

I am not getting any output.

[MK_QSL]

how you are using it? Provide sample script..

[varunreddy]

I actually want to get number of business days between [As of Date] and [Creation Date]

[Clever_Anjos]

Would you mind posting a sample of your app?

[Digvijay_Singh]

If your dates are in 'MM-DD-YYYY' then format is appearing correct. If dates are not in the used format then you need to use  - date(date#([As of Date],'<input date format'),'MM-DD-YYYY')

[maxgro · Accepted solution]

if you have text fields as in

=networkdays(date#('01-01-2015','MM-DD-YYYY'), date#('03-01-2015','MM-DD-YYYY'))

your expression should worh

if you have date fields

networkdays([As of Date], [Creation Date])

[MK_QSL]

You will get it... But before that we need some input from you... Can you please provide the script which you are using?

[varunreddy]

Hi Manish,

I don't have access to send you the application

Thanks & Regards,

Varun