How to have dynamic date range

I want the date range to be dynamic.
7/01/2022 will always be constant but the second date should be yesterdays.

So basically I need 7/01/2022 as text followed by a formula to get yesterday's date

Let me know if there is way to do this