Access ecuviant for Excel Date Function

[dgkindy]

I am trying to convert an excel formula to be used in access. One of the functions used in the calculation is the Date function.

What is the equivalent command in Access..


Excel formula
=INT(($D$2-(DATE(YEAR($D$2+(MOD(8-WEEKDAY($D$2),7)-3)),1,1))-3+ MOD(WEEKDAY(DATE(YEAR($D$2+(MOD(8-WEEKDAY($D$2),7)-3)),1,1))+1,7))/7)+1

 

[boblarson]

That would be

DateSerial(Year, Month, Day)