+ Reply to Thread
Results 1 to 11 of 11

auto-populate a date based on date began and other variable

  1. #1
    Registered User
    Join Date
    09-21-2017
    Location
    Ottawa, Ontario
    MS-Off Ver
    2013-2016
    Posts
    9

    auto-populate a date based on date began and other variable

    I'm currently trying to get a future date to auto populate.
    Cell A: current date
    Cell B: multiple drop down variable
    Cell C: future date

    I want the future date in cell C to auto populate based on the current date and whichever dropdown variable that's selected.

    For ex,
    Cell A: 13/10/2017
    Cell B: banana
    Cell C: 25/10/2017

    Cell B will have several options to choose from in the drop down list and depending on what is selected will determine which future date will be auto populated.

    Thanks for any help.

  2. #2
    Forum Expert sweep's Avatar
    Join Date
    04-03-2007
    Location
    Great Sankey, Warrington, UK
    MS-Off Ver
    2003 / 2007 / 2010 / 2016 / 365
    Posts
    3,440

    Re: auto-populate a date based on date began and other variable

    Hi,

    YOu could use index and match.

    For example, if "apple" in B means the future date is 10 days in the furture, "banana" means the future date is 20 days in the furture, and "pear" means the future date is 30 days in the future


    =A1+INDEX({10,20,30},MATCH(B1,{"apple","banana","pear"},0))
    Last edited by sweep; 10-16-2017 at 03:13 AM.
    Rule 1: Never merge cells
    Rule 2: See rule 1

    "Tomorrow I'm going to be famous. All I need is a tennis racket and a hat".

  3. #3
    Registered User
    Join Date
    09-21-2017
    Location
    Ottawa, Ontario
    MS-Off Ver
    2013-2016
    Posts
    9

    Re: auto-populate a date based on date began and other variable

    Should I be inputting this formula into the cell in which I want the date to be auto populated or the date in which the formula begins?

  4. #4
    Forum Expert sweep's Avatar
    Join Date
    04-03-2007
    Location
    Great Sankey, Warrington, UK
    MS-Off Ver
    2003 / 2007 / 2010 / 2016 / 365
    Posts
    3,440

    Re: auto-populate a date based on date began and other variable

    in column C - the result.

  5. #5
    Registered User
    Join Date
    09-21-2017
    Location
    Ottawa, Ontario
    MS-Off Ver
    2013-2016
    Posts
    9

    Re: auto-populate a date based on date began and other variable

    I cannot for the life of me get this to work. Here's the same problem but with accurate cell formation and some details, please help.

    SO here’s the issue….
    In cell C2 a date is produced. This date is produced when a while has begun to be worked on. In cell F2 there is a list drop down of complaints/correspondences in which we need to resolve or respond to. Each complaint/correspondence has a certain amount of time allotted in which it needs to be resolved, ranging between 3-20 days. What I’m trying to accomplish is once the file has begun to be worked on, based on that date and type of complaint or correspondence I need the ‘Due by” date to automatically populate under J2.

  6. #6
    Forum Expert sweep's Avatar
    Join Date
    04-03-2007
    Location
    Great Sankey, Warrington, UK
    MS-Off Ver
    2003 / 2007 / 2010 / 2016 / 365
    Posts
    3,440

    Re: auto-populate a date based on date began and other variable

    I think I understand, but can you please attach a sample of the sheet you're trying to work with? Please give a "current state" and an example of what you'd like it to look like when working.

  7. #7
    Registered User
    Join Date
    09-21-2017
    Location
    Ottawa, Ontario
    MS-Off Ver
    2013-2016
    Posts
    9

    Re: auto-populate a date based on date began and other variable

    Here's a copy of the file and the cells I'm trying to get to work.

    I've been searching all over and one solution I found that's effective for only one option in cell F2, however once I change it to one of the other options it doesn't seem to work.

    =IF(F2="Complaint",C2+12,EOMONTH(C2,0)+12)

    Thanks for any advice

  8. #8
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,419

    Re: auto-populate a date based on date began and other variable

    Where is the lookup table of allotted times for each procedure?
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    Don't forget to say "thank you" in your thread to anyone who has offered you help.
    You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.

    Forum Rules (updated August 2023): please read them here.

  9. #9
    Registered User
    Join Date
    09-21-2017
    Location
    Ottawa, Ontario
    MS-Off Ver
    2013-2016
    Posts
    9

    Re: auto-populate a date based on date began and other variable

    It is included in the attached document roughly 300 cells down.
    Last edited by rcm4486; 10-17-2017 at 10:04 AM.

  10. #10
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Retired in Ipswich, Suffolk, but grew up in Sawley, Derbyshire (England)
    MS-Off Ver
    MS 365 Subscription Insider Beta Channel v. 2404 (Windows 11 22H2 64-bit)
    Posts
    79,419

    Re: auto-populate a date based on date began and other variable

    And where has the attachment gone?

  11. #11
    Registered User
    Join Date
    09-21-2017
    Location
    Ottawa, Ontario
    MS-Off Ver
    2013-2016
    Posts
    9

    Re: auto-populate a date based on date began and other variable

    Sorry about that, included above.

+ 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. [SOLVED] Auto Populate Excel Calendar based on Date Ranges
    By mikearmanios in forum Excel General
    Replies: 14
    Last Post: 04-01-2021, 12:11 PM
  2. [SOLVED] Auto Populate a Linear Calendar Based On A List With Date Ranges
    By falafelologist in forum Excel General
    Replies: 3
    Last Post: 05-20-2015, 08:15 PM
  3. Replies: 5
    Last Post: 08-04-2014, 06:42 PM
  4. Replies: 1
    Last Post: 05-26-2014, 03:46 AM
  5. Replies: 0
    Last Post: 07-03-2012, 03:52 PM
  6. trying to auto populate based of changing a date
    By grenes in forum Excel General
    Replies: 1
    Last Post: 06-21-2011, 06:17 PM
  7. HOW ?Excel chart auto insert /populate a code based on date
    By MikeR-Oz in forum Excel - New Users/Basics
    Replies: 6
    Last Post: 12-22-2005, 08:20 AM

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