1. Computing

Calculate a Project End Date in Excel

By , About.com Guide

2 of 2

Excel 2010 NETWORKDAYS.INTL Function
Calculate the Number of Days Betw

Calculate the Number of Days Between Two Dates in Excel

© Ted French

Table of Weekend Number Codes and Corresponding Weekend Days

For Locations with a Two Day Weekend

Number        Weekend days 
1 or omitted    Saturday, Sunday 
      2              Sunday, Monday
      3              Monday, Tuesday
      4              Tuesday, Wednesday
      5              Wednesday, Thursday
      6              Thursday, Friday
      7              Friday, Saturday

For Locations with a One Day Weekend

Number      Weekend day 
     11              Sunday
     12              Monday 
     13              Tuesday
     14              Wednesday
     15              Thursday
     16              Friday
     17              Saturday 

©2013 About.com. All rights reserved.