Need understanding on - Network formula + some nested formula's

VBABEGINER

Well-known Member
Joined
Jun 15, 2011
Messages
1,130
Dear All,
Can any one pls explain me how this formula works..
=(NETWORKDAYS($AF2,$AG2,Lookup_table!$J$2:$J$10)-1)*("19:00"-"7:00")+IF(NETWORKDAYS($AG2,$AG2,Lookup_table!$J$2:$J$10),MEDIAN(MOD($AG2,1),"19:00","7:00"),"19:00")-MEDIAN(NETWORKDAYS($AF2,$AF2,Lookup_table!$J$2:$J$10)*MOD($AF2,1),"19:00","7:00")

*Lookup_table sheet = J2 - J10 = holiday list
*AF = start date
*AG = close date

Pls explain..
 

Some videos you may like

Excel Facts

Links? Where??
If Excel says you have links but you can't find them, go to Formulas, Name Manager. Look for old links to dead workbooks & delete.

Watch MrExcel Video

Forum statistics

Threads
1,108,756
Messages
5,524,677
Members
409,597
Latest member
Dannydev

This Week's Hot Topics

Top