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.

[TABLE="width: 67"]
<tbody>[TR]
[TD]Date[/TD]
[/TR]
[TR]
[TD][/TD]
[/TR]
[TR]
[TD]8/12/15[/TD]
[/TR]
[TR]
[TD]8/13/15[/TD]
[/TR]
[TR]
[TD]8/16/15[/TD]
[/TR]
[TR]
[TD]8/17/15[/TD]
[/TR]
[TR]
[TD]8/18/15[/TD]
[/TR]
[TR]
[TD]8/19/15[/TD]
[/TR]
[TR]
[TD]8/20/15[/TD]
[/TR]
[TR]
[TD]8/23/15[/TD]
[/TR]
</tbody>[/TABLE]

 

[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.