+ Reply to Thread
Results 1 to 2 of 2

Start dates, end dates and # of Days

Hybrid View

  1. #1
    Registered User
    Join Date
    08-18-2011
    Location
    New York, NY
    MS-Off Ver
    Excel 2003
    Posts
    12

    Start dates, end dates and # of Days

    Preface: I am working on a template scheduling file for construction management. I have Suretrack and know about Microsoft Project but I want a something specific (functionally and aesthetically) and simple (once it is locked).

    Problem: I want to make it so that there are three columns where a Start Date, End Date, and number of days can be entered.

    Depending on which column the user chooses to place input (minimum 2 input values), I want the other (3rd) value to be calculated. I know how to do each individually: If the number of work days are provided, I simply add that value to the start date. If the end date is provided, I use the networkdays function to determine the number of workdays. My problem is that I need to make it user friendly for someone using the template.

    I want the user to choose the input (maybe with a drop-down menu?) and have the other value calculated.

    Thanks for your help!

  2. #2
    Valued Forum Contributor gjlindn's Avatar
    Join Date
    08-01-2011
    Location
    Dodgeville, WI
    MS-Off Ver
    Excel 2003, 2007, 2010, 2013
    Posts
    369

    Re: Start dates, end dates and # of Days

    Would something like the attached example work?
    Attached Files Attached Files
    -Greg If this is helpful, pls click Star icon in lower left corner

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

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