X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
> Add Working Days To A Query, Any Version    
post Oct 16 2019, 09:29 AM

Posts: 1
Joined: 16-October 19


Im hoping someone out there can help me to add a number of working days to an existing date. Excluding weekends. Eg, add 3 working days to a date. In my current query, I have =[Date]+5, but of course this does not exclude working days. Is there something I can put into this query to exclude these?

Ive looked at other responses and all have the answer of creating VBA to resolve this. Im afraid I dont know any VBA at all, just know how to create queries.
If this is the only solution, how do I do this; how do I put this into my query? What do I type; how do I link this into my query

I have MS Access on Office 365

Any help appreciated

Thanks in advance!

Go to the top of the page

Posts in this topic

Custom Search

RSSSearch   Top   Lo-Fi    14th December 2019 - 04:57 AM