Excel Formula help - Network Days minus certain dates in the date range ......

Hi Smiffy,

Use formula like shown below:-

=NETWORKDAYS(A13,B13,{"12/15/2011","12/16/2011"}

So you can write the dates within curly brackets and surround them in double quotes.

Regards,
DILIPandey

<click on below 'star' if this helps>

OR, just this....

=NETWORKDAYS(A13;B13-27/12-15/12-14/12-13/12-12/12)

Hope to helps you.

I dont think your second formula will work.
It will take the date 27/12/2011 convert it into an Excel serial number and subtract it from the date in B13
So you're not saying NETWORKDAYS from A1 to B1 less 1 date, instead you're saying
NETWORKDAYS from A1 to (whatever the result of B1-27/12/2011 is)
so if B1 is 28/12/2011 it's gonna be NETWORKDAYS(A1,1)

Anyway back to your main problem
Do the NOTEs at the bottom of this page help at all in reference to your problem?
http://office.microsoft.com/en-us/ex...010342719.aspx

Duplicate reply by me

Hi Special-K.

I dont think your second formula will work.

My poor...English don't allow me to explain by words..

But for me, it work...

Pls, take a look to the attachement..