Outlook Banter

Outlook Banter (http://www.outlookbanter.com/)
-   Outlook and VBA (http://www.outlookbanter.com/outlook-vba/)
-   -   Dateadd issue (http://www.outlookbanter.com/outlook-vba/19975-dateadd-issue.html)

Nick_NZ July 6th 06 10:11 PM

Dateadd issue
 
Hi,

I have a dateadd function that adds five days onto a task's due date in
Outlook. However I need a way of excluding non working days (ie Sat & Sun)
from this calculation.

Any one got any ideas??

Ken Slovak - [MVP - Outlook] July 6th 06 11:13 PM

Dateadd issue
 
Interval = "w"

--
Ken Slovak
[MVP - Outlook]
http://www.slovaktech.com
Author: Absolute Beginner's Guide to Microsoft Office Outlook 2003
Reminder Manager, Extended Reminders, Attachment Options
http://www.slovaktech.com/products.htm


"Nick_NZ" wrote in message
...
Hi,

I have a dateadd function that adds five days onto a task's due date in
Outlook. However I need a way of excluding non working days (ie Sat & Sun)
from this calculation.

Any one got any ideas??




All times are GMT +1. The time now is 03:49 PM.

Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Search Engine Friendly URLs by vBSEO 2.4.0
Copyright ©2004-2006 OutlookBanter.com