Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help fixing date to be the past Thursday
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 -- nbaj2k ------------------------------------------------------------------------ nbaj2k's Profile: http://www.excelforum.com/member.php...o&userid=36480 View this thread: http://www.excelforum.com/showthread...hreadid=571358 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Help fixing date to be the past Thursday
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) "nbaj2k" wrote in message ... 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 -- nbaj2k ------------------------------------------------------------------------ nbaj2k's Profile: http://www.excelforum.com/member.php...o&userid=36480 View this thread: http://www.excelforum.com/showthread...hreadid=571358 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Fixing date of entry | Excel Worksheet Functions | |||
how do i set date as 1st thursday of every month | Excel Worksheet Functions | |||
Populating an excel calendar - eg. 10x tuesday/thursday from date x | Links and Linking in Excel | |||
When I convert a date to a weekday, Sunday becomes Thursday? | Excel Worksheet Functions | |||
Fixing the date. | New Users to Excel |