Outlook Banter

Outlook Banter (http://www.outlookbanter.com/)
-   Outlook - Using Forms (http://www.outlookbanter.com/outlook-using-forms/)
-   -   Calculate date and consider weekends (http://www.outlookbanter.com/outlook-using-forms/5704-calculate-date-consider-weekends.html)

Tonya Renfrow March 6th 06 09:08 PM

Calculate date and consider weekends
 
I am trying to enter a formula and have it automatically consider the weekend.

Example if I enter a info date into a field that is programmed to add 3 days
or add one day and the day is Thursday or Friday I would end up with a
weekend day.
How can I get away from that?

Sue Mosher [MVP-Outlook] March 7th 06 12:18 AM

Calculate date and consider weekends
 
The code sample at http://www.outlookcode.com/codedetail.aspx?id=153 should help you with this.

--
Sue Mosher, Outlook MVP
Author of Configuring Microsoft Outlook 2003
http://www.turtleflock.com/olconfig/index.htm
and Microsoft Outlook Programming - Jumpstart for
Administrators, Power Users, and Developers
http://www.outlookcode.com/jumpstart.aspx


"Tonya Renfrow" wrote in message ...
I am trying to enter a formula and have it automatically consider the weekend.

Example if I enter a info date into a field that is programmed to add 3 days
or add one day and the day is Thursday or Friday I would end up with a
weekend day.
How can I get away from that?



All times are GMT +1. The time now is 06:15 AM.

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