add weekdays in query

[Bumi66]

Hi Everyone, I'm new to this forum. I was looking for an answer but I couldn't find an easy way to solve my problem.
I have a query and I try to add days business days to a date e.g if its a Friday I need to add 3 days instead of 1.
Is there an easy way without VBA codes ? and if it's a VBA code where do i add it in the query ?
the field is called [Invoice date] and I need to calculate the arrival date at the customer what is usually 1 business day later.

Thanks in advance

 

[Minty]

You will have to resort to some VBA, have a look at the thread linked at the bottom of this thread for some starters.

Do you also want to account for Holidays as well?

Welcome to AWF by the way!

 

[JHB]

You can use the function WeekDay:
Look a the query in the attached database:

 

[Bumi66]

Awesome JHB that was exactly what I was looking for.
Thank you very very much, You made my day

 

[Bumi66]

Minty, I can't open that link

To view links or images in signatures your post count must be 10 or greater. You currently have 1 posts.

 

[JHB]

Awesome JHB that was exactly what I was looking for.
Thank you very very much, You made my day

You're welcome, good luck!