(1) Outlook, add a date without holidays

Home	\| General \| General2 \| Contacts \| Calendaring \| Installation \| Printing \| Addins \| Forms \| Forms2 \| Interop \| VBA \| VBA2 \| BCM \| Third-party Utils

Go back to group page | Go to next unread message | Fixed font

Subject: Re: add a date without holidays
Author: Christian W
Date: 27 May 2010
References: 1 2

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 [MVP - Outlook]" 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 - MVP Outlook
> Category Manager - Easily share your categories:
> SAM - Automatically choose sending account, signature, and sent message
> folder:
> <http://www.vboffice.net/product.html?lang=en>
>
>
> 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

> .
>

Mark all as read

21 May 2010	add a date without holidays	.Christian W
22 May 2010	$\$ Re: add a date without holidays	.Michael Bauer [MVP - ...
27 May 2010	$\$ Re: add a date without holidays	.Christian W