Hi,

I have a sheet which uses the first row as a calendar of sorts, a bit like the following...

31/01/2022	01/02/2022	02/02/2022	03/02/2022	04/02/2022
REF1	        REF3			
REF2		REF4	        REF7	        REF8	        REF9		
			REF5	
			REF6

I'm looking to be able to pull all REFs for the current day and for that to dynamically update every day.
What I'd like it to look like is:

Jobs for today: "<---assuming today was 01/02/2022 in this example"
REF3
REF4
REF5
REF6


I have tried using the today function along with HLOOKUP but thus far I have had zero luck.

Is anybody able to help? Thanks
As simple as possible ideally as I am not overly advanced in Excel.