+ Reply to Thread
Results 1 to 5 of 5

If a cell in a column equals today's date return the value of another cell adjacent to it

  1. #1
    Registered User
    Join Date
    09-21-2012
    Location
    Melbourne, Australia
    MS-Off Ver
    Excel 2003
    Posts
    29

    If a cell in a column equals today's date return the value of another cell adjacent to it

    In Column A I have a range of dates
    In Column B I have irrelevant data
    In Column C I have a list of funds
    In Cell D1 I would like to return the value of today's funds

    Excel Question.JPG

    I have hacked a formula from another part of my spreadsheet (See Formula in image) but I know it's not the right way to do it. Is there a simpler way of doing this?
    Hopefully my image shows (My first post) and thank you in advance.
    (I am using Excel 2003)

  2. #2
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    51,474

    Re: If a cell in a column equals today's date return the value of another cell adjacent to

    Try this...

    =sumif(A:A,TODAY(),C:C)
    1. Use code tags for VBA. [code] Your Code [/code] (or use the # button)
    2. If your question is resolved, mark it SOLVED using the thread tools
    3. Click on the star if you think someone helped you

    Regards
    Ford

  3. #3
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    51,474

    Re: If a cell in a column equals today's date return the value of another cell adjacent to

    Happy to help, thanks for the feedback

  4. #4
    Registered User
    Join Date
    09-21-2012
    Location
    Melbourne, Australia
    MS-Off Ver
    Excel 2003
    Posts
    29

    Re: If a cell in a column equals today's date return the value of another cell adjacent to

    Just checking that I did in fact thank you! I can't see a comment from me saying thanks so If I didn't ... "Thank you". (I haven't been here for quite some time!)

  5. #5
    Administrator FDibbins's Avatar
    Join Date
    12-29-2011
    Location
    Duncansville, PA USA
    MS-Off Ver
    Excel 2000/3/7/10/13/16
    Posts
    51,474

    Re: If a cell in a column equals today's date return the value of another cell adjacent to

    I got a "thank you" in the rep notification

+ 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. Replies: 4
    Last Post: 09-12-2013, 11:32 PM
  2. [SOLVED] Copying today's date into cell when multiple data is entered into adjacent cell
    By SChapman in forum Excel Programming / VBA / Macros
    Replies: 14
    Last Post: 04-16-2013, 04:12 PM
  3. Replies: 4
    Last Post: 02-13-2013, 01:18 PM
  4. Replies: 1
    Last Post: 04-03-2012, 11:33 AM
  5. Look up Today's Date & Return Cell Value
    By mandii01 in forum Excel General
    Replies: 4
    Last Post: 02-23-2011, 07:23 PM

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