Return Seven working days excluding Fridays and Saturdays (1 Viewer)

Alhakeem1977

Registered User.
Local time
Today, 07:33
Joined
Jun 24, 2017
Messages
308
Hi everyone,
I have got two fields [Opened Date] and [Due Date], I would like to return the due date of 7 working days excluding Fridays and Saturdays from current date.

How can achieve this by macro and the same by VBA too afterupdate event?

Thanks in advance!

Sent from my HUAWEI NXT-L29 using Tapatalk
 

Alhakeem1977

Registered User.
Local time
Today, 07:33
Joined
Jun 24, 2017
Messages
308

theDBguy

I’m here to help
Staff member
Local time
Yesterday, 21:33
Joined
Oct 29, 2018
Messages
18,962
Hi. For both problems, take a look at these two functions. fAddWorkdays() adds a number of working days to a date, and fNetWorkdays() calculates the difference in working days between two dates. Hope it helps...
 
Last edited:

Gasman

Enthusiastic Amateur
Local time
Today, 05:33
Joined
Sep 21, 2011
Messages
10,531
The links are under Similar Threads at the bottom of the page.?

This one appears to be the nearest to what you want.

https://www.access-programmers.co.uk/forums/showthread.php?t=168965

plus theDBguys link also gives you a method.

Thanks for your prompt response.
Unfortunately, it was for another database, plus when scroll down I did not see any link.

Is there a simple way to achieve it?
Sorry for my limited knowledge in Access.

Thanks in advance!

Sent from my HUAWEI NXT-L29 using Tapatalk
 

Alhakeem1977

Registered User.
Local time
Today, 07:33
Joined
Jun 24, 2017
Messages
308
Hi. For both problems, take a look at these two functions. fAddWorkdays() add a number of working days to a date, and fNetWorkdays() calculates the difference in working days between two dates. Hope it helps...
Thanks theDBguy for response.
I will try it once I reach home and will let you know the result.

Sent from my HUAWEI NXT-L29 using Tapatalk
 

theDBguy

I’m here to help
Staff member
Local time
Yesterday, 21:33
Joined
Oct 29, 2018
Messages
18,962
Thanks theDBguy for response.
I will try it once I reach home and will let you know the result.

Sent from my HUAWEI NXT-L29 using Tapatalk
Good luck! Let us know if you get stuck.
 

Alhakeem1977

Registered User.
Local time
Today, 07:33
Joined
Jun 24, 2017
Messages
308

Alhakeem1977

Registered User.
Local time
Today, 07:33
Joined
Jun 24, 2017
Messages
308
What has that post got to do with working days? :confused:
Sorry dear it's entirely another post nothing to do with working days.

I am struggling with it I do not know how structure the control form.



Sent from my HUAWEI NXT-L29 using Tapatalk
 

Users who are viewing this thread

Top Bottom