Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]() 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
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]() 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 |
Display Modes | |
|
|