Formula works in excel 2010 .. but not in sharepoint 2010…
Sharepoint 2010 doesn’t support networkdays in calculated values
Require assistance in converting below exccel formula to sharepoint 2010
=ROUND((NETWORKDAYS([Actual Start],[Actual End])*8)-IF(WEEKDAY([Actual Start],2)>=6,0,MIN(MAX(24*(MOD([Actual Start],1)-“9:00”),0),8)) – IF(WEEKDAY([Actual End],2)>=6,0,MIN(24*MAX((“17:00”-MOD([Actual End],1)),0),8)),2)+ROUND((NETWORKDAYS([Actual Start1],[Actual End 1])*8)-IF(WEEKDAY([Actual Start1],2)>=6,0,MIN(MAX(24*(MOD([Actual Start1],1)-“9:00”),0),8)) – IF(WEEKDAY([Actual End 1],2)>=6,0,MIN(24*MAX((“17:00”-MOD([Actual End 1],1)),0),8)),2)+ROUND((NETWORKDAYS([Actual Start 2],[Actual End 2])*8)-IF(WEEKDAY([Actual Start 2],2)>=6,0,MIN(MAX(24*(MOD([Actual Start 2],1)-“9:00”),0),8)) – IF(WEEKDAY([Actual End 2],2)>=6,0,MIN(24*MAX((“17:00”-MOD([Actual End 2],1)),0),8)),2)+ROUND((NETWORKDAYS([Actual Start 3],[Actual End 3])*8)-IF(WEEKDAY([Actual Start 3],2)>=6,0,MIN(MAX(24*(MOD([Actual Start 3],1)-“9:00”),0),8)) – IF(WEEKDAY([Actual End 3],2)>=6,0,MIN(24*MAX((“17:00”-MOD([Actual End 3],1)),0),8)),2)+ROUND((NETWORKDAYS([Actual Start 4],[Actual End 4])*8)-IF(WEEKDAY([Actual Start 4],2)>=6,0,MIN(MAX(24*(MOD([Actual Start 4],1)-“9:00”),0),8)) – IF(WEEKDAY([Actual End 4],2)>=6,0,MIN(24*MAX((“17:00”-MOD([Actual End 4],1)),0),8)),2)
