VBABEGINER
Well-known Member
- Joined
- Jun 15, 2011
- Messages
- 1,232
VBA Code:
=(NETWORKDAYS($AG2,$AH2,Lookup_table!$J$2:$J$10)-1)*("19:00"-"7:00")+IF(NETWORKDAYS($AH2,$AH2,Lookup_table!$J$2:$J$10),MEDIAN(MOD($AH2,1),"19:00","7:00"),"19:00")-MEDIAN(NETWORKDAYS($AG2,$AG2,Lookup_table!$J$2:$J$10)*MOD($AG2,1),"19:00","7:00")
here AG and AH contains date column
from J2 to J10 - holiday list
can anyone please explain me how it is working exactly.. appreciate in advance