Getting Info from Today's Date

[zahidislam14]

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.

[TABLE="width: 256"]
<colgroup><col><col><col></colgroup><tbody>[TR]
[TD][/TD]
[TD][/TD]
[TD][/TD]
[/TR]
[TR]
[TD][TABLE="width: 500"]
<tbody>[TR]
[TD]Station Name[/TD]
[TD]Machine#[/TD]
[TD]Installation Date[/TD]
[/TR]
[TR]
[TD]Station A[/TD]
[TD]111[/TD]
[TD]June 4, 2018[/TD]
[/TR]
[TR]
[TD]Station B[/TD]
[TD]112[/TD]
[TD]June 5, 2018[/TD]
[/TR]
</tbody>[/TABLE]
[/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
[TR]
[TD][/TD]
[TD="align: right"][/TD]
[TD="align: right"][/TD]
[/TR]
</tbody>[/TABLE]
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:

[TABLE="width: 500"]
<tbody>[TR]
[TD]Station Name[/TD]
[TD]Machine#[/TD]
[TD]Installation Date[/TD]
[/TR]
[TR]
[TD]Station B[/TD]
[TD]112[/TD]
[TD]June 5, 2018[/TD]
[/TR]
</tbody>[/TABLE]


Please help with this. Thank you.

 

[jtakw]

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.

Book1
	A	B	C
1	Station Name	Machine#	Installation Date
2	Station A	111	4-Jun-18
3	Station B	112	5-Jun-18
4
5
6	Station Name	Machine#	Installation Date
7	Station B	112	5-Jun-18
Sheet68

Cell Formulas
Range	Formula
A7	=INDEX(A2:A3,MATCH($C7,$C2:$C3,0))
C7	=TODAY()