Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 5
Default 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
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Dav Dav is offline
external usenet poster
 
Posts: 1
Default 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

  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 5
Default 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


  #4   Report Post  
Posted to microsoft.public.excel.worksheet.functions
external usenet poster
 
Posts: 1
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On



All times are GMT +1. The time now is 02:04 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"