+ Reply to Thread
Results 1 to 2 of 2

How to auto populate date range (working days only) from start date and end date

  1. #1
    Registered User
    Join Date
    05-25-2014
    Posts
    1

    How to auto populate date range (working days only) from start date and end date

    Hi I am now trying to create a excel macro to auto populate all the dates with reference to a start date and end date. The catch is that only working days are required in the range. My reference cells (start and end date) are in Sheet 1 while the destination cell range are in Sheet 2. The reason for creating a macro instead of a function is that the intervals between the start date and end date changes frequently (annual, semi-annual and quarterly) Best case scenario would be a button which I can just press after i input the dates to generate the range of dates in another sheet. Would appreciate any assisstance on this thanks!

  2. #2
    Forum Guru Kaper's Avatar
    Join Date
    12-14-2013
    Location
    Warsaw, Poland
    MS-Off Ver
    most often 365, but still time to time use also older versions
    Posts
    8,373

    Re: How to auto populate date range (working days only) from start date and end date

    Within a macro you can easily refer to worksheethunctions. Here you shall refer to
    Please Login or Register  to view this content.
    or workday.intl (depending on your excel version - please edit this info in your profile http://www.excelforum.com/profile.php?do=editprofile)
    Best Regards,

    Kaper

+ 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. Calculate End Date Using Start Date and No. of Days excluding specific days.
    By SinusxCosinusx in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 11-22-2013, 05:48 AM
  2. [SOLVED] Calculate END DATE based on START DATE & No of working days
    By prashantha in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 11-20-2013, 07:22 AM
  3. Replies: 0
    Last Post: 07-03-2012, 03:52 PM
  4. Replies: 2
    Last Post: 01-04-2012, 09:15 AM
  5. Start Date, End Date=#of days not working
    By readingteacher in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-19-2007, 06:43 PM

Tags for this Thread

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