+ Reply to Thread
Results 1 to 9 of 9

Addition of Date When A Cell Is Populated

  1. 01-30-2016, 12:58 PM #1
    STBTC
    STBTC is offline
    Forum Contributor
    Join Date
    12-22-2015
    Location
    San Antonio, Texas
    MS-Off Ver
    2016
    Posts
    116

    Addition of Date When A Cell Is Populated

    Book1.xlsx I have attached a worksheet for elucidation. Each row is its own entry. Columns C & D are date columns; they are already formatted to display the date. I need column D to stay blank until a date has been added to Column C. Column D would have a date seventeen days from Column C.
    Exempli gratia, cell C2 is given a date of 01-01-16. Cell D2 would then display a value of 01-18-16, not before. The formula would apply to the whole column. I'm sure that there is a easy way; I just don't see it. Sorry. Thanks in advance! I need a course in this.
    Reply With QuoteRegister To Reply
  2. 01-30-2016, 01:09 PM #2
    sourabhg98
    sourabhg98 is offline
    Forum Expert sourabhg98's Avatar
    Join Date
    10-22-2014
    Location
    New Delhi, India
    MS-Off Ver
    Excel 2007, 2013
    Posts
    1,899

    Re: Addition of Date When A Cell Is Populated

    Use this in D2 and copy down-
    Please Login or Register  to view this content.
    Happy to Help

    How to upload excel workbooks at this forum - http://www.excelforum.com/the-water-...his-forum.html

    "I don't get things easily, so please be precise and elaborate"

    If someone's post has helped you, thank by clicking on "Add Reputation" below the post.
    If your query is resolved please mark the thread as "Solved" from the "Thread Tools" above.

    Sourabh
    Reply With QuoteRegister To Reply
  3. 01-30-2016, 01:21 PM #3
    STBTC
    STBTC is offline
    Forum Contributor
    Join Date
    12-22-2015
    Location
    San Antonio, Texas
    MS-Off Ver
    2016
    Posts
    116

    Re: Addition of Date When A Cell Is Populated

    =IF(C2="","",C2+17)

    I get a return of #VALUE for the cell. Is there a way to apply it to the whole column? I don't know how many dates will be added; it will be for the whole year. There may be fifty-two, five hundred, or one thousand dates added. It is by what is received from the client.
    Reply With QuoteRegister To Reply
  4. 01-30-2016, 01:35 PM #4
    sourabhg98
    sourabhg98 is offline
    Forum Expert sourabhg98's Avatar
    Join Date
    10-22-2014
    Location
    New Delhi, India
    MS-Off Ver
    Excel 2007, 2013
    Posts
    1,899

    Re: Addition of Date When A Cell Is Populated

    Why are you getting an error?
    Check attached.
    Also you can keep the formula pasted to a large range lets say 1000 rows or whatever you feel is the maximum number of rows you would probably have.
    So just copy the cell D2, select the range you want to paste it in. Right click on the selected range>> paste special>>formulas.
    Attached Files Attached Files
    Reply With QuoteRegister To Reply
  5. 01-30-2016, 03:27 PM #5
    STBTC
    STBTC is offline
    Forum Contributor
    Join Date
    12-22-2015
    Location
    San Antonio, Texas
    MS-Off Ver
    2016
    Posts
    116

    Re: Addition of Date When A Cell Is Populated

    The range is unknown. Is there a way to just apply it to the whole column?
    Reply With QuoteRegister To Reply
  6. 01-30-2016, 05:53 PM #6
    JohnTopley
    JohnTopley is online now
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,207

    Re: Addition of Date When A Cell Is Populated

    Just drag formula down for as many rows as you require.
    Reply With QuoteRegister To Reply
  7. 02-02-2016, 03:27 PM #7
    STBTC
    STBTC is offline
    Forum Contributor
    Join Date
    12-22-2015
    Location
    San Antonio, Texas
    MS-Off Ver
    2016
    Posts
    116

    Re: Addition of Date When A Cell Is Populated

    I want it applied to the whole column, but I cannot drag it 1048576 rows. That would take too long.
    Reply With QuoteRegister To Reply
  8. 02-02-2016, 03:45 PM #8
    ChemistB
    ChemistB is offline
    Forum Guru
    Join Date
    08-05-2004
    Location
    NJ
    MS-Off Ver
    365
    Posts
    13,582

    Re: Addition of Date When A Cell Is Populated

    If you have the formula fill the entire column, you will get error messages should you ever try to insert a row. The general rule is guess at how much data you willl have maximum and then add 10%.
    So if you might get 50,000 entries, the final row would be 55000 (much less than over 1 million!)

    To fill in the formula lets say it will be in column R
    Go to the name box and type in R2:R55000 and enter
    Excel will select that range.
    In Formula box, type =IF(C2="","",C2+17)
    hold down the contrl key and hit enter.
    Formula will autopopulate R2:R55000
    ChemistB
    My 2?

    substitute commas with semi-colons if your region settings requires
    Don't forget to mark threads as "Solved" (Edit First post>Advanced>Change Prefix)
    If I helped, Don't forget to add to my reputation (click on the little star at bottom of this post)

    Forum Rules: How to use code tags, mark a thread solved, and keep yourself out of trouble
    Reply With QuoteRegister To Reply
  9. 02-02-2016, 03:45 PM #9
    JohnTopley
    JohnTopley is online now
    Forum Expert
    Join Date
    05-05-2015
    Location
    UK
    MS-Off Ver
    Microsoft Excel for Microsoft 365 MSO (Version 2402 Build 16.0.17328.20068) 64-bit
    Posts
    28,207

    Re: Addition of Date When A Cell Is Populated

    In suggest you don't want over 1 million rows; There will be a performance cost at some point .

    But if you insist on the whole column ..

    Copy cell D2

    Ctrl+Shift + "Down Arrow" to select whole column

    Paste


    See previous posting from ChemistB
    Last edited by JohnTopley; 02-02-2016 at 03:51 PM.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. If Function Help- If Cell is populated with a date or Y Populate with N
    By mnunnley in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 12-01-2014, 11:44 AM
  2. Calculate only if cell is populated by a date
    By TYRANNUS CENTRE in forum Excel General
    Replies: 6
    Last Post: 08-25-2014, 05:45 AM
  3. Macro that changes a cell when another one has a date populated in it.
    By photochic10 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-15-2013, 09:25 AM
  4. [SOLVED] Prompt input of future date in cell when another cell has been populated or modified
    By coffeemints in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 03-07-2013, 06:46 PM
  5. Date and Dollar Concatenation populated in one cell.
    By RowdyRodie in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 01-20-2013, 11:23 PM
  6. How do you add a date stamp to one cell once another is populated?
    By mal1006 in forum Excel General
    Replies: 1
    Last Post: 08-08-2012, 12:47 PM
  7. [SOLVED] Entering date depending on another cell being populated
    By wurz in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-21-2006, 07:10 AM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1