Thread: Change Date code to yesterday/day before ,,,,
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
J.W. Aldridge J.W. Aldridge is offline
external usenet poster
  
Posts: 425
Default 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")


Reply With QuoteReply With Quote