# Getting Info from Today's Date

#### zahidislam14

##### New Member
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

<tbody>
</tbody>

<colgroup><col><col><col></colgroup><tbody>
</tbody>
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

<tbody>
</tbody>

Please help with this. Thank you.

### Excel Facts

How to find 2nd largest value in a column?
MAX finds the largest value. =LARGE(A:A,2) will find the second largest. =SMALL(A:A,3) will find the third smallest

#### jtakw

##### Well-known Member
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.

<b></b><table cellpadding="2.5px" rules="all" style=";background-color: rgb(255,255,255);border: 1px solid;border-collapse: collapse; border-color: rgb(187,187,187)"><colgroup><col width="25px" style="background-color: rgb(218,231,245)" /><col /><col /><col /></colgroup><thead><tr style=" background-color: rgb(218,231,245);text-align: center;color: rgb(22,17,32)"><th></th><th>A</th><th>B</th><th>C</th></tr></thead><tbody><tr ><td style="color: rgb(22,17,32);text-align: center;">1</td><td style=";">Station Name</td><td style=";">Machine#</td><td style=";">Installation Date</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">2</td><td style=";">Station A</td><td style="text-align: right;;">111</td><td style="text-align: right;;">4-Jun-18</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">3</td><td style=";">Station B</td><td style="text-align: right;;">112</td><td style="text-align: right;;">5-Jun-18</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">4</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">5</td><td style="text-align: right;;"></td><td style="text-align: right;;"></td><td style="text-align: right;;"></td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">6</td><td style=";">Station Name</td><td style=";">Machine#</td><td style=";">Installation Date</td></tr><tr ><td style="color: rgb(22,17,32);text-align: center;">7</td><td style=";">Station B</td><td style="text-align: right;;">112</td><td style="text-align: right;;">5-Jun-18</td></tr></tbody></table><p style="width:5.6em;font-weight:bold;margin:0;padding:0.2em 0.6em 0.2em 0.5em;border: 1px solid rgb(187,187,187);border-top:none;text-align: center;background-color: rgb(218,231,245);color: rgb(22,17,32)">Sheet68</p><br /><br /><table width="85%" cellpadding="2.5px" rules="all" style=";border: 2px solid black;border-collapse:collapse;padding: 0.4em;background-color: rgb(255,255,255)" ><tr><td style="padding:6px" ><b>Worksheet Formulas</b><table cellpadding="2.5px" width="100%" rules="all" style="border: 1px solid;text-align:center;background-color: rgb(255,255,255);border-collapse: collapse; border-color: rgb(187,187,187)"><thead><tr style=" background-color: rgb(218,231,245);color: rgb(22,17,32)"><th width="10px">Cell</th><th style="text-align:left;padding-left:5px;">Formula</th></tr></thead><tbody><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">A7</th><td style="text-align:left">=INDEX(<font color="Blue">A2:A3,MATCH(<font color="Red">\$C7,\$C2:\$C3,0</font>)</font>)</td></tr><tr><th width="10px" style=" background-color: rgb(218,231,245);color: rgb(22,17,32)">C7</th><td style="text-align:left">=TODAY(<font color="Blue"></font>)</td></tr></tbody></table></td></tr></table><br />

Threads
1,106,243
Messages
5,510,025
Members
408,775
Latest member
stjuch

### This Week's Hot Topics

• Turn fraction around
Hello I need to turn a fraction around, for example I have 1/3 but I need to present as 3/1
• TIme Clock record reformatting to ???
Hello All, I'd like some help formatting this (Tbl-A)(Loaded via Power Query) [ATTACH type="full" width="511px" alt="PQdata.png"]22252[/ATTACH]...
• TextBox Match
hi, I am having a few issues with my code below, what I need it to do is when they enter a value in textbox8 (QTY) either 1,2 or 3 the 3 textboxes...
• Using Large function based on Multiple Criteria
Hello, I can't seem to get a Large formula to work based on two criteria's. I can easily get a oldest value based one value, but I'm struggling...
• Can you check my code please
Hi, Im going round in circles with a Compil Error End With Without With Here is the code [CODE=rich] Private Sub...
• Combining 2 pivot tables into 1 chart
Hello everyone, My question sounds simple but I do not know the answer. I have 2 pivot tables and 2 charts that go with this. However I want to...