Reference new cell based on Today

[advsign]

Hello,
I have a production report to capture totals made for the day, each day, each date. I currently have to change the cell reference manually each day myself.

I would like to have the daily Total cell referenced based off of the =Today, so I don't have to do the daily manual cell references.

Thanks,

 

[Fluff]

Hi & welcome to MrExcel.
How about

=xlookup(today(),a2:a100,b2:b100)

 

[RudRud]

Maybe this?

Book1
	A	B	C	D	E
1	date	date
2	7/1/2023	1			888
3	7/2/2023	2			888
4	7/3/2023	3
5	7/4/2023	4
6	7/5/2023	5
7	7/6/2023	6
8	7/7/2023	7
9	7/8/2023	8
10	7/9/2023	9
11	7/10/2023	10
12	7/11/2023	11
13	7/12/2023	888
14	7/13/2023	13
15	7/14/2023
16	7/15/2023
17	7/16/2023
18	7/17/2023
19	7/18/2023
20	7/19/2023
21	#######
Sheet1

Cell Formulas
Range	Formula
E2	E2	=XLOOKUP(TODAY(),A:A,B:B)
E3	E3	=INDEX(B:B,MATCH(TODAY(),A:A),0)

 

[advsign]

Getting there. Sorry the first post should have said referencing the day before date, not today.

Example: 06:00 today 07/12, I need to do a report for the date of yesterday 7/11

Thanks

 

[Fluff]

In that case you can use

=xlookup(today()-1,a2:a100,b2:b100)

Do the values in col A contain a time & date, or just date?