+ Reply to Thread
Results 1 to 3 of 3

Create a date range with user entered dates

  1. #1
    Registered User
    Join Date
    11-22-2011
    Location
    Pennsylvania, USA
    MS-Off Ver
    Office 365
    Posts
    2

    Create a date range with user entered dates

    I am creating a tracking sheet and need some help. The problem I am having is this, the way they want to set it up is have the user enter a start date and end date, then have excel generate all the dates in between. Users will then enter values in several columns and the **** will add everything up.

    My problem is generating the date range. I can do it with auto fill but have no idea how to do it automatically. I am not an excel wizard and have done the pre-cursory google search but came up with nothing (But am perhaps searching for the wrong thing).

    Thanks for any help.

  2. #2
    Forum Contributor
    Join Date
    06-24-2006
    Location
    UK
    MS-Off Ver
    Excel 2010
    Posts
    127

    Re: Create a date range with user entered dates

    Something like the attached might help you...
    Attached Files Attached Files

  3. #3
    Registered User
    Join Date
    11-22-2011
    Location
    Pennsylvania, USA
    MS-Off Ver
    Office 365
    Posts
    2

    Re: Create a date range with user entered dates

    Any other way to do it without macros? My boss is kind of being specific about it.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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