+ Reply to Thread
Results 1 to 9 of 9

Outputting a cells value based on another cell being equal to todays date

  1. #1
    Registered User
    Join Date
    03-28-2019
    Location
    Sheffield, England
    MS-Off Ver
    2018
    Posts
    5

    Outputting a cells value based on another cell being equal to todays date

    Hi I'm hoping someone can help,

    As you can see I have a range of dates in A1:A10
    These dates have a corresponding set of values in B1:B10

    Where the text is red (call it D5), I would like to output the value in the B column, corresponding to when the date in the A column is todays date

    For example if the date were 05/04/2019 the output shows 4345
    Attached Images Attached Images

  2. #2
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    HOME: Excel 2007 - WORK: Excel 2013
    Posts
    7,010

    Re: Outputting a cells value based on another cell being equal to todays date

    in E1

    =IF(A1=TODAY(),B1,"")

    copy down the column
    Regards
    Special-K

    Ensure you describe your problem clearly, I have little time available to solve these problems and do not appreciate numerous changes to them.

  3. #3
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    21,275

    Re: Outputting a cells value based on another cell being equal to todays date

    Try this formula in E5:

    =IFERROR(VLOOKUP(TODAY(),$A:$B,2,0),"")

    Hope this helps.

    Pete

  4. #4
    Registered User
    Join Date
    03-28-2019
    Location
    Sheffield, England
    MS-Off Ver
    2018
    Posts
    5

    Re: Outputting a cells value based on another cell being equal to todays date

    Thank you both for your help

    I still can't quite figure it out and I think I may have written it poorly,

    I would only like one output cell
    using the TODAY function, this should change daily and then the output should be affected

    effectively what I would like It to do is to look at the range of dates in A1:A10, find the one which is equal to todays date, and then print the value from the corresponding cell in B1:B10

    I have been advised that INDEX and MATCH may be useful but I am unsure how they would work,

    Thanks again,
    Harry

  5. #5
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    HOME: Excel 2007 - WORK: Excel 2013
    Posts
    7,010

    Re: Outputting a cells value based on another cell being equal to todays date

    Have you tried any of the suggestions?

    Change your data to a date range that covers today's date, enter my formula as specified in column E.
    Only one date will appear if you have entered today's date once in that date range.

  6. #6
    Registered User
    Join Date
    03-28-2019
    Location
    Sheffield, England
    MS-Off Ver
    2018
    Posts
    5

    Re: Outputting a cells value based on another cell being equal to todays date

    Hi,
    Yep I did try the suggestions,
    However while you're correct that only one date will appear, I do not want a column of numbers etc, I just want the output to be in one specific cell,

  7. #7
    Forum Expert
    Join Date
    03-23-2004
    Location
    London, England
    MS-Off Ver
    HOME: Excel 2007 - WORK: Excel 2013
    Posts
    7,010

    Re: Outputting a cells value based on another cell being equal to todays date

    Then use Pete_UK's formula - it works.

  8. #8
    Registered User
    Join Date
    03-28-2019
    Location
    Sheffield, England
    MS-Off Ver
    2018
    Posts
    5

    Re: Outputting a cells value based on another cell being equal to todays date

    Thank you,

    Sorry I misunderstood to begin with,
    Your help is appreciated

  9. #9
    Forum Guru Pete_UK's Avatar
    Join Date
    12-31-2011
    Location
    Warrington, England
    MS-Off Ver
    Office 2019 (still learning)
    Posts
    21,275

    Re: Outputting a cells value based on another cell being equal to todays date

    Thanks for the rep - glad you got it working in the end.

    If that takes care of your original question, please take a moment to select Thread Tools from the menu above and to the right of your first post in this thread, and mark the thread as SOLVED.

    Pete

+ 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. Copy cells to worksheet based on todays date
    By heffers1 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 02-05-2018, 05:35 PM
  2. How do i Grey out cells when the date does not equal todays date?
    By rcork23 in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 12-15-2015, 03:57 PM
  3. Replies: 5
    Last Post: 01-05-2015, 03:57 PM
  4. Blank cellls if date are equal on larger than todays' date
    By kuzna26 in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 12-31-2013, 06:50 AM
  5. VBA to format cells based on difference from todays date
    By Cantdoexcel in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 12-07-2012, 04:27 AM
  6. Using VB to find a range based on todays date and todays date +30
    By Steve_al in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 08-13-2009, 09:31 AM
  7. Filling cells with 3 different colors based on date in cell and todays date
    By chinookcrew in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 07-23-2009, 07:36 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1