Multiple goals based on days, stop calculating once a goal is met

[Realtor Chicago Team]

I have set up a 160 day multi-goal program for new members of my team. Each goal gets a bonus once it is hit.
60-day goal
90-day goal
120 Day goal
160 Day Goal

How do I stop a cell from calculating and show that they hit the goal based on days that have elapsed? Or more realistically, at day 60, 90, 120, 160 lock in the result that they had at that point....... 1 deal within 60 days if yes hit once "yes" stop calculating or once 60 days is hit, it just locks it where it is "yes" or "no"

A	B	C	D	E	F	G	H
Name	Start Date	Days in position	Total # deals Closed	60-day goal is 1 closed within 60 days	90-day goal is 2 closed within 90 days	120-day goal is 4 closed	160-day goal is 5 closed
John Smith	11/29/2021	=TODAY()-B9	entered each day in total	=if(D1>=1,c1<=60),"yes","no")	=if(D1>=2,c1<=90),"yes","no")	=if(D1>=4,c1<=120),"yes","no")	=if(D1>=5,c1<=160),"yes","no")

 

[Toadstool]

Hi Realtor Chicago Team,

I'm not sure if I'm following correctly but it seems you want the lowest target reached to be the only one shown. I'd suggest replacing "No" with just null "" as it makes it easier to read. The problem is the history can't be saved, so for example Harry Mix may have met goal 1 in the past but no longer meets that criteria so has no goal achieved.

Realtor Chicago Team.xlsx
	A	B	C	D	E	F	G	H
1	Days				60	90	120	160
2	Closed				1	2	4	5
3	Name	Start Date	Days in position	Total # deals Closed	60-day goal is 1 closed within 60 days	90-day goal is 2 closed within 90 days	120-day goal is 4 closed	160-day goal is 5 closed
4	John Smith	11/29/2021	59	3	Yes
5	Sue Jones	9/9/2021	140	6				Yes
6	Bob Jones	11/11/2021	77	5		Yes
7	Tim Lane	12/12/2021	46	2	Yes
8	Harry Mix	9/9/2021	140	4
9	Kim Kalls	12/12/2021	46	4	Yes
10	Mary Pool	10/2/2021	117	5			Yes
Sheet1

Cell Formulas
Range	Formula
E4:H10	E4	=IF(AND($C4<=E$1,$D4>=E$2,COUNTIF($D4:D4,"Yes")=0),"Yes","")
C4:C10	C4	=TODAY()-B4