Posted to microsoft.public.excel.programming

J.W. Aldridge J.W. Aldridge is offline

external usenet poster

Posts: 425

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 Quote

Thread Tools	Search this Thread
Show Printable Version	Search this Thread: Advanced Search
Display Modes
Linear Mode Switch to Hybrid Mode Switch to Threaded Mode

Posting Rules
Smilies are On [IMG] code is On HTML code is Off Trackbacks are On Pingbacks are On Refbacks are On

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Change Date code to yesterday/day before ,,,,	J.W. Aldridge	Excel Programming	1	January 13th 09 04:00 PM
Change Date code to yesterday/day before ,,,,	J.W. Aldridge	Excel Programming	0	January 13th 09 03:44 PM
Date formats change (code included)	Paolo	Excel Programming	9	December 1st 08 02:11 AM
macro code to open a file dated yesterday	DB74	Excel Programming	4	September 9th 07 03:30 PM
VBA code for date change? (Newbie)	DekHog	Excel Programming	5	June 3rd 07 05:07 PM

All times are GMT +1. The time now is 12:24 AM.

About Us

"It's about Microsoft Excel"

Menu

About Us