Workdays formula

[John liem]

Is there any formula I can use to calculate a date in workingdays (excl. weekend).
Record has a date value of today (August 4th) +10 days, the result then, will show August 18th. Thanks
for example, things like this:
workdays(date()+10) ?

 

[ColinEssex]

Have a look at this thread

http://www.access-programmers.co.uk/forums/showthread.php?s=&threadid=46960&highlight=weekdays+only

Credits to Mile-O-Phile

Col

 

[John liem]

Thanks, I'll give a try
John.

 

[John liem]

Hi Mile,

I got this error message (#error) if the start date is "blank", do you know how I can get a blank result if the date is not fill in?
John.

 

[Mile-O]

Why is your start date blank?
What are you trying to do?
How do you expect to count the number of days if you don't begin with a range to calculate upon?

 

[John liem]

Hi Mile,

The start date is blank because sometimes this field is not needed to be filled in due to the logic of the database.
This is a "repair return date". If there is no repair, this field will not be populated and the "reminder date" (repair return date + 10 workingdays) will then give this error message "#error".
John.

 

[Mile-O]

Use the IIf() function in a ControlSource first (with the IsNull() function.

i.e.

=IIf(IsNull(txtYourTextbox), "-", yourFunction(txtYourTextbox, 10)

 

[John liem]

Thanks Mile, it works fine ....
John.

 

[racdata]

Test

This is a test please ignore