This site uses different types of cookies, including analytics and functional cookies (its own and from other sites). To change your cookie settings or find out more, click here. If you continue browsing our website, you accept these cookies.
A Formula might be the easiest way, but if you want to manage it through a Text Input you could use something along these lines:
This adds all the thresholds to every record, checks which thresholds are less than the Days column, and grabs the largest threshold. The RecordID tool is just to provide a unique field for the Unique tool --- if you have another field(s) that make each record unique, you can use those instead and eliminate the RecordID.