Try this:
SWITCH(
DATETIME_FORMAT(
{Send Date},
'ddd'
),
'Sat', DATEADD({Send Date}, -1, 'days'),
'Sun', DATEADD({Send Date}, -2, 'days'),
'Mon', DATEADD({Send Date}, -3, 'days'),
'Tue', DATEADD({Send Date}, -1, 'days'),
'Wed', DATEADD({Send Date}, -1, 'days'),
'Thu', DATEADD({Send Date}, -1, 'days'),
'Fri', DATEADD({Send Date}, -1, 'days')
)
![Screenshot 2024-02-28 at 10.33.40 AM.png Screenshot 2024-02-28 at 10.33.40 AM.png](/t5/image/serverpage/image-id/32893i982BCE43043FF0B8/image-size/medium?v=v2&px=400)