How to have dynamic date range

[Vkapoor565]

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

[#2]

@Vkapoor565 That would be:

="7/01/2022-"&TEXT(TODAY()-1,"m/dd/yyyy")