ExcelBanter - Change Date code to yesterday/day before ,,,,

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Change Date code to yesterday/day before ,,,, (https://www.excelbanter.com/excel-programming/422388-change-date-code-yesterday-day-before.html)

J.W. Aldridge

Change Date code to yesterday/day before ,,,,

How to change this portion:

& Format(Now, "mmm-dd-yy ddd")

of the line to reflect the day before today or yesterday?

(Full line here)
.Subject = "My recap" & " " & Format(Now, "mmm-dd-yy ddd")

All times are GMT +1. The time now is 01:44 PM.