Help fixing date to be the past Thursday

  • Thread starter Thread starter nbaj2k
  • Start date Start date
N

nbaj2k

I was wondering if someone can help me, I know some people helped me to
figure out the code so that it would come up with the date of "The most
recent thursday", but now I need it to be the header of an email in a
macro.

This is what I have right now, but it is coming up with August 11th,
instead of the 9th.

..Subject = "Thursday Reports through " & Format(Date - Weekday(Today -
4), "mmm-d-yy")

Is there something that is a little off?

Thanks,

~J
 
Subject = "Thursday Reports through " & Format(Date - Weekday(Date - 4),
"mmm-d-yy")

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

trying to find the previous thursday before running a macro 6
Simplify save code 11
Updating Dates to Next Specific Weekday Automatically 1
Date Variable 1
Help needed to writing a macro to put the year in column B of a tableusing Table nomenclature & the 7
Date format. 1
VBA in Excel 2007 date formatting 2
find the first thursday from a given month 6

Back
Top