+ Reply to Thread
Results 1 to 2 of 2

IF - Date triggered by specific text value

  1. #1
    Registered User
    Join Date
    03-26-2020
    Location
    Dallas
    MS-Off Ver
    2016
    Posts
    1

    IF - Date triggered by specific text value

    First post, so hopefully I attached my example properly.

    I want to be able to insert "Y" into Column D in order to populate in column E the date in which the "Y" was entered.

    I want G to produce the date in which both D & F have "Y".

    I have used formula's such as =IF(D9="Y", TODAY(), "") but using the TODAY() makes the date in that cell change whenever the actual date changes.

    I was told I may have to create a macro to hard code the data after calculated.
    Attached Files Attached Files
    Last edited by Jacapone; 03-27-2020 at 09:58 AM.

  2. #2
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 (Mac OSX) (16.83 (24031120))
    Posts
    8,685

    Re: IF - Date triggered by specific text value

    this should work,
    BUT you need to set the iterations to 1 , See calculations section, usually set to 100 - change to 1
    in E5 put
    =IF(D5="","",IF(AND(E5="",D5="Y"),NOW(),E5))
    and copy down

    I have entered Y in row 5 & 6
    and it puts todays date 27/3 in E5 & E6
    tomorrow they should stay as that date

    http://www.howtoexcelatexcel.com/exc...with-formulas/
    Attached Files Attached Files
    Wayne
    if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here

    If you have a solution to your thread - Please mark your thread solved do the following: >
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

+ 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] Open/Load TEXT file with Specific Date and start at specific Cell
    By chergian in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 06-09-2017, 09:29 AM
  2. [SOLVED] Sound alert when specific value is triggered (worksheet attached)
    By zeegerman in forum Excel Programming / VBA / Macros
    Replies: 16
    Last Post: 07-24-2015, 01:25 AM
  3. [SOLVED] Only COUNT or SUM value in a row when triggered by a specific letter.
    By azalex in forum Excel Formulas & Functions
    Replies: 7
    Last Post: 10-16-2012, 09:45 PM
  4. [SOLVED] code or macro to be triggered when selecting specific data
    By chiidzzz in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 09-11-2012, 10:45 AM
  5. Date triggered formating
    By mat_hump3 in forum Excel General
    Replies: 3
    Last Post: 10-31-2011, 11:02 AM
  6. Automatically entering a row in another tab, triggered by a specific value in a cell
    By Patrick L in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 06-15-2011, 02:50 PM
  7. [SOLVED] display a range of data when triggered by a specific condition
    By colligan25 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 02-25-2006, 07:35 PM

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