Getting Info from Today's Date
Results 1 to 2 of 2

Thread: Getting Info from Today's Date
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Jun 2018
    Posts
    1
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Getting Info from Today's Date

    Hello All,

    This is my first post, so first of all, I apologize if I am doing something wrong.

    I need help with a formula that will fetch data from a cell or number of cells in a column by matching today's date with another column of dates.

    Station Name Machine# Installation Date
    Station A 111 June 4, 2018
    Station B 112 June 5, 2018
    So, I want a daily report that will look at the current date and if it matches with "Installation Date" it will return both all the column. So if I run the report today (June 5, 2018) it will return:

    Station Name Machine# Installation Date
    Station B 112 June 5, 2018


    Please help with this. Thank you.

  2. #2
    Board Regular
    Join Date
    Jun 2014
    Location
    Oakland, CA
    Posts
    5,146
    Post Thanks / Like
    Mentioned
    42 Post(s)
    Tagged
    2 Thread(s)

    Default Re: Getting Info from Today's Date

    Hi,

    This will do what you asked.

    If you want the report to be "automatic" for each and every day, then use the C7 formula; otherwise manually enter an Installation Date to lookup.
    A7 formula copied across to B7.

    ABC
    1Station NameMachine#Installation Date
    2Station A1114-Jun-18
    3Station B1125-Jun-18
    4
    5
    6Station NameMachine#Installation Date
    7Station B1125-Jun-18

    Sheet68



    Worksheet Formulas
    CellFormula
    A7=INDEX(A2:A3,MATCH($C7,$C2:$C3,0))
    C7=TODAY()


Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •