What Formula Can I Use to Compare the Difference in Month-to-Date numbers?

[ParkourAngel]

I want to compare the cumulative target with the current value so that I can see the pace I am at any given day for the month. What formula can I use that will only use the current date value and only compare it to that day's cumulative value?

 

[Kaper]

Have a look on two options below.
Either you enter (yellow cells) cumulative current values each day as in your screenshot (row 3, and results in row 4 - see formula in B5 and copied right)
or you just give a cumulative value for given day, like in row 7 (yellow) and formula looks up the cumulative target for that day. See cell D7 formula.

Book2
	A	B	C	D	E	F	G	H	I	J	K	L	M	N	O	P	Q
1	Date	01.02.2025	02.02.2025	03.02.2025	04.02.2025	05.02.2025	06.02.2025	07.02.2025	08.02.2025	09.02.2025	10.02.2025	11.02.2025	12.02.2025	13.02.2025	14.02.2025	15.02.2025	16.02.2025
2	cumulative target	10	20	30	40	50	60	70	80	90	100	110	120	130	140	150	160
3	current	8	18	26	38	52	59	74	89	97	102	112	124	132	144
4	perform.	80%	90%	87%	95%	104%	98%	106%	111%	108%	102%	102%	103%	102%	103%
5
6	Or	Today result		Today perform.
7		144		103%
Sheet1

Cell Formulas
Range	Formula
B4:Q4	B4	=IF(B3<>"",B3/B2,"")
D7	D7	=B7/HLOOKUP(TODAY(),B1:Q2,2,0)

 

[ParkourAngel]

This worked great, thanks!

 

[Kaper]

Glad we could help.

@Joe4 : thanks for marking the answer as a solution!