add a date without holidays

Status
Not open for further replies.
C

Christian W

Hi friends,

I have a problem, in a macro I need to calculate a date adding working days

only.

This add not include saturday / sundays and holidays.

For example:

21/5 + 6 days = 31/5

How i can to do ?

Thanks in advance and sorry by my english,

Christian
 

Michael Bauer

Senior Member
Outlook version
Outlook 2010 32 bit
Email Account
Exchange Server
For adding days, use the DateAdd function. It won't return an invalid date

like 31/5.

The Weekday function returns the number of the day, for instance this

Weekday("22.05.2010" ,vbUseSystemDayOfWeek)

returns 6 for Saturday, tomorrow it will return 7 for Sunday.

For holidays I can't help off head.

Best regards

Michael Bauer

Category Manager - Easily share your categories:

SAM - Automatically choose sending account, signature, and sent message

folder:

Am Fri, 21 May 2010 11:30:01 -0700 schrieb Christian W:


> Hi friends,

> I have a problem, in a macro I need to calculate a date adding working


days
> only.

> This add not include saturday / sundays and holidays.

> For example:

> 21/5 + 6 days = 31/5

> How i can to do ?

> Thanks in advance and sorry by my english,
> Christian
 
C

Christian W

Michael,

yes, this function add dates, but i need to add 7 working days, but this

function add working days and non working days.

How i can only add working days without saturday and sunday ?

For example :

26/5/2010 + 7days = 4/6/2010 (not contain saturday and sundays)

Sorry my english.. Thanks in advance.

Christian

"Michael Bauer " wrote:



> For adding days, use the DateAdd function. It won't return an invalid date
> like 31/5.

> The Weekday function returns the number of the day, for instance this
> Weekday("22.05.2010" ,vbUseSystemDayOfWeek)

> returns 6 for Saturday, tomorrow it will return 7 for Sunday.

> For holidays I can't help off head.

> > Best regards
> Michael Bauer
> Category Manager - Easily share your categories:
> SAM - Automatically choose sending account, signature, and sent message
> folder:
>

> Am Fri, 21 May 2010 11:30:01 -0700 schrieb Christian W:
>
> > Hi friends,
> > I have a problem, in a macro I need to calculate a date adding working

> days
> > only.
> > This add not include saturday / sundays and holidays.
> > For example:
> > 21/5 + 6 days = 31/5
> > How i can to do ?
> > Thanks in advance and sorry by my english,
> > Christian

> .
>
 
Status
Not open for further replies.
Similar threads
Thread starter Title Forum Replies Date
L Macro to add Date & Time etc to "drag to save" e-mails Outlook VBA and Custom Forms 15
D Add date next to day name in Outlook Today calendar view Using Outlook 1
M Macro to add date/time stamp to subject Outlook VBA and Custom Forms 4
C Need VBA code to automatically save message outside outlook and add date Outlook VBA and Custom Forms 1
A Email Macro to add Date and Classification Outlook VBA and Custom Forms 2
P How do i add the date to subject header of incoming mail? Outlook VBA and Custom Forms 13
0 Add a date stamp to the note field of a custom form Outlook VBA and Custom Forms 1
kkqq1122 How would I add Search for attachment name Outlook VBA and Custom Forms 3
L did MS ever add way to text via Outlook Using Outlook 5
P How to add a column named categories when searching in Outlook Using Outlook 0
M add new attendee to existing meetings with VBA Outlook VBA and Custom Forms 5
N Can't create NEW GROUP and add/remove a member from existing Group in Outlook Using Outlook 1
witzker Outlook 2019 Pls. add a Prefix for OUTLOOK 2019 here Using Outlook 1
P Add inanimate objects to meetings? Using Outlook 1
O Outlook 2010 Add delete button to the side of the message list Using Outlook 1
BartH Add a string to the conditions in .Conditions.BodyOrSubject.Text Outlook VBA and Custom Forms 2
A "Get Add-Ins" - Which Version of Outlook to use Using Outlook 1
D Do I need Exchange Add-In? Using Outlook 6
C-S-R Manage Add-ins (Remove Wunderlist) Using Outlook 6
A iCloud add in problems Using Outlook 4
C Looking for feedback on new Outlook Add-in Using Outlook 0
L isn't there an OL add-on that flags addressee before sending Using Outlook 3
S Add VBA save code Using Outlook 0
P Shortcut Pane - add shortcut to Office365 group mailbox Using Outlook 1
Z Add ComboBox Value to Body of Email Outlook VBA and Custom Forms 1
G How to add a folder shortcut to outlook quick access toolbar? Using Outlook 6
G Add to Outlook Contacts - Point to non-default contacts folder Using Outlook 0
M Automatically add senders first name to a greeting Outlook VBA and Custom Forms 1
C Add Form to Appointments Received, Automatically Outlook VBA and Custom Forms 6
O Outlook tasks - Add text column with multiple lines Using Outlook 3
W April 2020 Office 365 Update - Add-Ons fail after Office 365 Update Using Outlook 6
Z Task Filter Not Working When I add too many criteria Using Outlook 0
D iCloud Add-in not working in Outlook 2013 and Outlook 2016 After Windows Upgrade & iCloud Upgrade Using Outlook 2
P Add Paste Unformatted to QAT Using Outlook 1
M Ignore slow add-ins Using Outlook 0
B Add Prefix text to Subject Line Using Outlook 1
Jennifer Murphy Add birthdays to calendar Using Outlook 7
Z Add text to auto-forwarded e-mail Outlook VBA and Custom Forms 4
P Add, remove, & reorder folder pane Using Outlook 6
L Tired of Outlook disabling Adobe PDF Creator add-in Using Outlook 1
R Add 'Company' to Select Names Form Using Outlook 1
A Outlook 2016 Web add-in missing on some machines Using Outlook 9
P Syncing problems with add-ins Using Outlook 3
Mark Foley Cannot enable add-in in outlook 2010 Using Outlook 0
BretAB Is it possible to add a lookup field to a Message form? Outlook VBA and Custom Forms 4
J Add an Attachment Using an Array and Match first 17 Letters to Matching Template .oft to Send eMail Outlook VBA and Custom Forms 2
iwshim outlook 2013 - I cannot see the "Manage Add-ins" Using Outlook 2
A Add multiple servers "on behalf of" email to "safe senders" list. Using Outlook 1
S Add Exchange Account as Secondary to Existing PST? Exchange Server Administration 1
C Macro to add multiple recipients to message Outlook VBA and Custom Forms 3

Similar threads

Top