# Works: Calculating Number of Working Days Between Two Dates

This article has been archived. It is offered "as is" and will no longer be updated.
##### SUMMARY
You can calculate the number of workdays between two arbitrary datesby using the following formula in conjunction with the days left tableshown below
=Int((EndDay-StartDay)/7)*5+VlookUp(Mod((EndDay-StartDay),7),A3:H9, Choose(Mod(StartDay,7),1,2,3,4,5,6,7))
where StartDay is the starting date and EndDay is the ending date of the time span you are trying to find the number of working days for.

### DAYS LEFT TABLE

The Days Left table uses cells A3:H9 as shown:
`        A      B    C    D    E    F     G    H 1                  Day Started 2 Days Left  Sat  Sun  Mon  Tue  Wed  Thur  Fri 3      0      0    0    0    0    0     0    0 4      1      0    1    1    1    1     1    0 5      2      1    2    2    2    2     1    0 6      3      2    3    3    3    2     1    1 7      4      3    4    4    3    2     2    2 8      5      4    5    4    3    3     3    3 9      6      5    5    4    4    4     4    4				`