I think you should do three SQL sensors. One for 1 day ago, one for 2 days ago and one for 3 days ago.
You can then use one of the custom cards that does templating, eg https://github.com/thomasloven/lovelace-template-entity-row
I am rubbish at date/time templating, but this thread is awesome. The EPIC Time Conversion and Manipulation Thread!
You want to template something like (now() - 3days) formatted as %A
(%A is weekday in full, eg Saturday)