+ Reply to Thread
Results 1 to 4 of 4

How do I make a date in a drop down menu populat other cells with folloeing days

  1. #1
    Registered User
    Join Date
    03-09-2013
    Location
    Afghanistan
    MS-Off Ver
    Excel 2007
    Posts
    17

    How do I make a date in a drop down menu populat other cells with folloeing days

    My timesheet mission is almost complete. One question at a time. My next question is this: attached is the Timesheet (working copy), in cell C3 (yellow fill)i have a dropdown menu with two week time periods (i.e. 2 Mar-15 Mar). In the cells with red fill i have the actual day by day time periods. What im trying to do is when i select the time period from cell C3 (yellow fill drop down menu), for it to the auto populat the daily cells (red fill) with correct dates.

    *The attached spreadsheet has the current format: I select date from C3 (dropdown menu), then i manually type in the first date in cell F4, then the rest of the cells auto populate by using the =F4+1, etc.

    Thank you...

  2. #2
    Forum Expert dredwolf's Avatar
    Join Date
    10-27-2012
    Location
    Clearwater,Canada
    MS-Off Ver
    Excel 2007
    Posts
    2,649

    Re: How do I make a date in a drop down menu populat other cells with folloeing days

    This is where those merged cells are goig to Bite You!..the basic formula is easy, But the merged cells make it FAR more complex...
    Try this in F4..drag across :
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Hope this helps
    A picture may be worth a thousand words, BUT, a sample Workbook is worth a thousand screenshots!
    -Add a File - click advanced (next to quick post), scroll to manage attachments, click, select add files, click select files, select file, click upload, when file shows up at bottom left, click done (bottom right), click submit
    -To mark thread Solved- go top of thread,click Thread Tools,click Mark as Solved
    If you received helpful response, please remember to hit the * of that post

  3. #3
    Forum Expert
    Join Date
    07-20-2011
    Location
    Mysore, India.
    MS-Off Ver
    Excel 2019
    Posts
    8,513

    Re: How do I make a date in a drop down menu populat other cells with folloeing days

    Pl see attached file. Formula in F column.
    Attached Files Attached Files

  4. #4
    Registered User
    Join Date
    03-09-2013
    Location
    Afghanistan
    MS-Off Ver
    Excel 2007
    Posts
    17

    Re: How do I make a date in a drop down menu populat other cells with folloeing days

    Thank you gentleman, timeshet is almost complete... I have a few more questions that I will submit in a few hours.


    Eddie Elvis

+ 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