+ Reply to Thread
Results 1 to 3 of 3

Formula to insert future date in cell, if specific information placed in other cell

  1. #1
    Registered User
    Join Date
    11-22-2016
    Location
    Oxford, England
    MS-Off Ver
    2007
    Posts
    45

    Formula to insert future date in cell, if specific information placed in other cell

    Hello,
    I have to track information with a resolution date, however as I am not the only one using the spreadsheet, I want to eliminate the risk of someone "forgetting" to put a date in a field.

    Basically, if you review the attachment, in columns C or E, if option LR or HR is put in the cell, I need a resolution date in columns D or F (as applicable).

    I assume it would be the IF formula that I would use, but can you advise how to set it up so when LR/HR is input in the cell, the resolution date is automatically set for one month later?
    e.g. When LR (or HR) is entered in Cell C2, cell D2 would automatically show a date one month from then.

    I hope that this makes sense...
    Thanks

    Jen
    Attached Files Attached Files

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

    Re: Formula to insert future date in cell, if specific information placed in other cell

    Wrksheet event is used. Pl see file. Range used is $C$2:$C$100 & $E$2:$E$100. It can be changed as per requirement.
    Code
    Please Login or Register  to view this content.
    Attached Files Attached Files
    Pl note
    Array formula should be confirmed with Ctrl+Shift+Enter keys together.
    If answere is satisfactory press * to add reputation.

  3. #3
    Registered User
    Join Date
    11-22-2016
    Location
    Oxford, England
    MS-Off Ver
    2007
    Posts
    45

    Re: Formula to insert future date in cell, if specific information placed in other cell

    This is brilliant, thank you :-)

    Jen

+ 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. insert date and time as calender in specific cell
    By mazan2010 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-12-2016, 06:01 AM
  2. [SOLVED] Copy date from specific cell and insert to new row on another sheet
    By tony4444 in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 01-10-2016, 03:01 PM
  3. [SOLVED] Calculating a future date based on a specific cell date
    By Teuchter029 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-23-2015, 05:30 PM
  4. Insert Date When Cell in specific column is selected
    By G33kman in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 06-13-2013, 08:19 PM
  5. [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
  6. Insert a future date based on a number in another cell
    By LongShanks in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 05-10-2010, 10:48 AM
  7. [SOLVED] formula to calculate future date from date in cell plus days
    By Chicesq in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 11-03-2005, 08:30 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