Results 1 to 9 of 9

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

Threaded View

  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

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