Excel "Workday" function seems to gneerate wrong weekends

[Oldjugler]

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.

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>

 

[V_Malkoti]

Try changing your Date formula to DATE(2015, 8, 12). I think it is assuming 15 as 1915, and 12-Aug-1915 was Thursday.