Pass Down System Using Only Today's Date

[Justinian]

I am trying to create a pass down system where anyone can enter important daily events on a single log.

I want to take only today's information, shown in the table below, and have it placed on a separate tab so whenever the sheet is opened on a new day, only that day's issues appear:

12/06/22	Tower 48	Laundry room	Painting project
12/06/22	Block 31	Laundry room	Painting project
12/06/22	Tower 37	A/B/C	Hot water shutdown
12/07/22	Tower 41	G/H/J	Hot water shutdown

I can do this using table or pivots but some users are not that experienced and I would like Excel to only show today's issues when the log is opened.

Can anyone help?

 

[Justinian]

Sorry, I deleted it and now the formula is working!

Thank you!

 

[Joe4]

Sorry, I deleted it and now the formula is working!

Thank you!

You are welcome.
You just need to be aware that you cannot have formulas or data in range where the formula is trying to spill to!

 

[Justinian]

I understand now. Sorry for the confusion but I appreciate learning about FILTER.

 

[Joe4]

I understand now. Sorry for the confusion but I appreciate learning about FILTER.

Yeah, it really is a cool & powerful new function!