How to remove days from a date range

[stefanob]

Hello,
I am looking for a formula to remove some specific days from the count of days between two dates.

I want to calculate the difference in days between the two dates but also removing some specific days that fall in between the two days.
I am doing this because I need to subtract weekends and holidays from the count. I cannot use NETWORKDAYS() because I have a spreadsheet with Arabic week as well, however if anyone knows a workaround to that it would be excellent as well.


thanks!

[dilipandey]

Hi stefanob,

Welcome to the forum.

NETWORKDAYS(start_date,end_date,holidays)

Arabic issue can be worked upon.. I would still suggest you to use the networkdays function and put the days, in Holidays part of the syntax, which you want to remove from calculation.

Regards,
DILIPandey

<click on below 'star' if this helps>

[Bob Phillips]

stefan

what is the issue with NETWORKDAYS and Arabic week?

[darknation144]

Sunday is the first day of the week in the Arabic week.

[Bob Phillips]

Of course it is, I should have remembered that.

It is easily managed with NETWORKDAYS, just add 1 to the start and end dates, fool it into thinking that Sun is Mon, Mon is Tue, etc.

=NETWORKDAYS(A1+1,A2+1)

To cater for holidays, you need an adjusted range of holidays where each date is incremented by 1

=NETWORKDAYS(A1+1,A2+1,adjusted_holidays)

[stefanob]

I think this has done it, thank you very much!

Of course it is, I should have remembered that.

It is easily managed with NETWORKDAYS, just add 1 to the start and end dates, fool it into thinking that Sun is Mon, Mon is Tue, etc.

=NETWORKDAYS(A1+1,A2+1)

To cater for holidays, you need an adjusted range of holidays where each date is incremented by 1

=NETWORKDAYS(A1+1,A2+1,adjusted_holidays)

[Bob Phillips]

BTW, if you have Excel 2010, there is a new function NETWORKDAYS.INTL that addresses this issue

=NETWORKDAYS.INTL(A1,A2,7,holidays)