Calculate a Project End Date in Excel

By Ted French, About.com Guide

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 

Previous

• Calculate the Number of Days Between Two Dates in Excel
• Excel 2010 NETWORKDAYS.INTL Function

Next