date formula in access query 1

[brumy]

I need to exclude weekends in a query formula =dateadd ("y",+2,[date returned])

Date returned is when a package is provided to someone for corrections with an expected suspense of return 2 days later -- I just need to make sure the 2 days are work days only

Any help?

 

[Norris68]

=IIf(Weekday([Date Returned], vbSaturday) > 5, DateAdd("d", 4, [Date Returned]), DateAdd("d", 2, [Date Returned]))

Using vbSaturday as the first day of the week means that Thursday = 6 and Friday = 7, hence add 4 days; otherwise just add 2 days.