find No. of non working days between two dates

[#1]

Hello Friends,

I want the no. of non working days between two dates.

I know we can find no. of working days using NetWorkDays function. but this function returns only working working days which i don't want. I want only no. of non working days.

actuall i want to discard bank holidays and weekend between two dates difference.

Please help.

Thanks

Dipak

[alexandros17]

num

('30/06/2013'-'01/06/2013') +1

- NetWorkDays('01/06/2013', '30/06/2013', '02/06/2013')

[#3]

Thank you for reply.

yes it will helpful. Actually i have list of bank holidays with comma seprator but i also want to attach weekend dates between two dates in this list. Can you please help me in this?

Thanks

[alexandros17 · Accepted solution]

You don't have to attach weekend dates because "NetWorkDays" yet exclude them, so your expression will be:

Suppose yìthat you want to analysìze all 2013:



Num('31/12/2013'-'01/01/2013'+1-NetWorkDays('01/01/2013','31/12/2013', all your holydays date)

[#5]

Thank you very much. It will help me.