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
 
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
 
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 17
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
P Can't add custom field to custom Outlook form, it always adds to the Folder instead Outlook VBA and Custom Forms 2
P VBA to add email address to Outlook 365 rule Outlook VBA and Custom Forms 0
S Outlook 2019 Custom outlook Add-in using Visual Studio Outlook VBA and Custom Forms 0
G automatically choosing "add to autocorrect" option Using Outlook 0
F Want to add second email to Outlook for business use Using Outlook 4
K Add an entry to a specific calendar Using Outlook 1
F Add a category before "Send an Email When You Add an Appointment to Your Calendar" Outlook VBA and Custom Forms 0
J Want to create a button on the nav bar (module add-in) to run code Outlook VBA and Custom Forms 2
M "Attachment Detacher for Outlook" add in, does it update the server copy of the email? Using Outlook 1
J Outlook 365 Add keywords from Listbox to the message body where cursor is placed Outlook VBA and Custom Forms 0
O Add Day Number of the year for 2023-2033 Outlook VBA and Custom Forms 5
J GoDaddy migrated to Office365 - Outlook Wont Add Account Exchange Server Administration 21
F Outlook 2019 Outlook 2019 Add and Sync to New computer Comcast server Using Outlook 2
Witzker Add a text line at the end of the note field in all selected Contacts Outlook VBA and Custom Forms 7
A iCloud Outlook Add In is causing Outlook 2021 to crash and got disabled Using Outlook 10
N How to add or delete items to Move dropdown Menu Using Outlook 0
G Add contacts birthday to calendar Using Outlook 4
V How to add 'Previous Item' and 'Next Item' to the Quick Access Toolbar Using Outlook 1
Commodore Safe way to add or update holidays; Windows Notifications issue Using Outlook 8
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

Similar threads

Back
Top