New answers tagged


Use DAYS to calculate the total number of days between two days, and NETWORKDAYS.INTL to calculate the number of days excluding weekends. The difference is the number of days (net of weekends). Deduct this from the number of days from the simple formula End Datetime - Start DateTime) Use this formula: =(B3-A3)-((if(days(B3,A3)-NETWORKDAYS.INTL(A3,B3,1)<0,...

Top 50 recent answers are included