how do i remove default holiday format in XL i.e sat and sun?
 

while calculating Network days in XL(2003),saturday and sunday are by default
being taken as week end holidays, where in , if i want to use saturday and
sunday also as workding days(we have to use this sometimes if the resources
work on both days),what is the formula or the solution to have these days to
be included as working? Kindly help me on this error

how do i remove default holiday format in XL i.e sat and sun?
 

You are asking the number of days between 2 dates then. Just take one
number away from the other and add 1

Regards

Dav


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=558110

how do i remove default holiday format in XL i.e sat and sun?
 

hi,

you have not got my point. i am trying to calculate Networkdays from 1apr to
30apr where in its taking saturdays and sundays as holidays(even though i
dont refer them as holidays in the formula) by default and where in some of
the saturdays are working days at our office.

Pl. try to help if you can. XL version 2003


Regards,

Neha
"Dav" wrote:


You are asking the number of days between 2 dates then. Just take one
number away from the other and add 1

Regards

Dav


--
Dav
------------------------------------------------------------------------
Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
View this thread: http://www.excelforum.com/showthread...hreadid=558110

how do i remove default holiday format in XL i.e sat and sun?
 

by which function you are calculating?


--
starguy
------------------------------------------------------------------------
starguy's Profile: http://www.excelforum.com/member.php...o&userid=32434
View this thread: http://www.excelforum.com/showthread...hreadid=558110