|
| If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|||||||
|
|
Thread Tools | Search this Thread | Display Modes |
|
#2
May 22nd 10, 05:23 AM
posted to microsoft.public.outlook.program_vba
|
|||
|
|||
add a date without holidays
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 
|
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Thread Starter | Forum | Replies | Last Post |
| click date/time field display calendar and validation of date /tim | Smithskenpo | Outlook - Using Forms | 0 | March 4th 10 08:20 PM |
| need help with vba code to input data on certain date and move to next cell for the following date. | [email protected] | Outlook and VBA | 1 | May 30th 07 04:45 PM |
| Calcualting the time between email received date and reply date | Shanks | Outlook - General Queries | 3 | February 22nd 07 03:11 AM |
| Appointments display on date entered rather than date/time schedul | MaxRPeterson | Outlook - Calandaring | 0 | November 28th 06 04:49 PM |
| date fields - link the calander pop-up to a custom date field | Tom | Outlook - Using Forms | 0 | January 23rd 06 09:13 PM |
Threaded Mode