+ Reply to Thread
Results 1 to 3 of 3

Add X Days To Dates, Excluding Weekends and Holidays

  1. #1
    Registered User
    Join Date
    10-07-2013
    Location
    Malaysia
    MS-Off Ver
    Excel 2010
    Posts
    30

    Add X Days To Dates, Excluding Weekends and Holidays

    How to add a date with specific day and that will skip weekends and holidays with macro?

    What is the vba code like?

    Any help will be appreciate.

  2. #2
    Forum Expert
    Join Date
    11-28-2012
    Location
    Guatemala
    MS-Off Ver
    Excel 2010
    Posts
    2,394

    Re: Add X Days To Dates, Excluding Weekends and Holidays

    Do you mean how to add a number of working days to a date and come up with a new date?

  3. #3
    Registered User
    Join Date
    10-07-2013
    Location
    Malaysia
    MS-Off Ver
    Excel 2010
    Posts
    30

    Re: Add X Days To Dates, Excluding Weekends and Holidays

    Yes it is, this is what I need

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Replies: 7
    Last Post: 06-19-2013, 05:45 AM
  2. Calculate number of days excluding holidays and weekends
    By david1987 in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-05-2012, 08:17 AM
  3. Calculate number of days, excluding weekends and holidays
    By cloyd in forum Excel Formulas & Functions
    Replies: 5
    Last Post: 11-26-2012, 04:37 PM
  4. [SOLVED] Formula for adding days to a date excluding weekends and holidays?
    By Jake via OfficeKB.com in forum Excel General
    Replies: 2
    Last Post: 01-25-2006, 04:03 PM
  5. Replies: 2
    Last Post: 04-08-2005, 03:06 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1