Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
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)
num
('30/06/2013'-'01/06/2013') +1
- NetWorkDays('01/06/2013', '30/06/2013', '02/06/2013')
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
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)
Thank you very much. It will help me.