Re: $$Excel-Macros$$ Business Days Query

Dear Sushil, Please check below link, hope it might be help to you.. http://www.teachexcel.com/excel-help/interstitial.php?i=309802&src=button http://www.mrexcel.com/forum/showthread.php?t=451891 -- Thanks & regards, Noorain Ansari *http://noorainansari.com/*

Re: $$Excel-Macros$$ Business Days Query

Hi Sushil, In Networkdays formula, use NOW() function and then you can play around with Time available in NOW() as today() do not have this feature. Thanks. Regards, DILIPandey On 2/23/12, Sushil Kumar wrote: > Hi, > > i am using =networkdays(A1,today()) and cell A1 is 2/1/12. the problem >

$$Excel-Macros$$ Business Days Query

Hi, i am using =networkdays(A1,today()) and cell A1 is 2/1/12. the problem is, we have night shift in office and after 12:00 AM the business day changes to next day and the Value change form 16 to 17. is there any way so that this will not change before morning 7:00 AM. also, i cannot change the c