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
.