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.
Bookmarks