Yes, if you want the date to change without any input from the user, then you’ll need background refresh or else the date (and app) will only update when something in the sheet changes.
See my post below for how to build a refresh button into the app for this very purpose. It would only show for the first user each day (until the day matches “today” ).