DateAdd function not working properly for me!

[dmcfarland9]

Hey guys,

I am using the dateadd funtion to add weekdays to my date, but it appears to be including the weekends as well. Can you help?? I am attempting to add 25 weekdays (Mon-Fri) to the reservation_date field. When I use the funtion below, it returns the date plus 25 days...

Dateadd("W", 25, [reservation_date])

ex:
reservation_date = 3/8/19
Dateadd("W", 25, [reservation_date]) returns 4/2/19 instead of 4/12/19.

Thanks!!

 

[James006]

Hello,

Have you tested :

=WORKDAY(A2,25)

with cell A2 holding your reservation_date ...

HTH

 

[dmcfarland9]

That looks like it may work in Excel, but not in Access.

 

[xenou]

Doesn't look like the function works as advertised. You will have to write or find your own workday function.

Some examples:
http://www.fmsinc.com/microsoftaccess/modules/examples/AddWeekdays.asp
https://access-programmers.co.uk/forums/showthread.php?t=118886