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
> .
>