This could very easily be operator error but---this list of dates below (generated with the Workday function) indicates that August 13 is a Friday (instead of a Thursday) then skips the next days as if they were the weekend. The August 12 date was entered with [=DATE(15,8,12)] and the subsequent dates with [=WORKDAY(D3,1,$A$4:$A$11)] where D3 was the cell containing the August 12, 2015 date and the [$A$4:$A$11] was a cell range of dates to be left out. So, what is necessary to make Excel know that 8/12 is a Wednesday and appropriately omit the weekends?
Many thanks.
<tbody>
</tbody>
Many thanks.
Date |
8/12/15 |
8/13/15 |
8/16/15 |
8/17/15 |
8/18/15 |
8/19/15 |
8/20/15 |
8/23/15 |
<tbody>
</tbody>