View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Jimi Jimi is offline
external usenet poster
 
Posts: 7
Default Increment a Variable Defined Date by 1 day

Bob,

Didn't mean to confuse anyone "11/12/2004 was a typo. I was looking to
increment by one day. Thanks for your answer. I had my variable incorrectly
identified as a "single". Fixed and all is well.

Thanks!!!!

"Bob Phillips" wrote:

How do you come to the conclusion that
10/11/2004 plus 1 is 11/12/2004.

If you meant 10/12/2004, then

strDate + 1 gives you the date 1 day later than 10/11/2004 as long as
strDate is a date variable, or a variant loaded with a date.

--

HTH

RP

"JimI" wrote in message
...
I have defined a date variable with a date [MM/DD/YYYY] as the first day

of
the week [Monday]. I would like to increment the date variable by 1 day.
This should be straightforward but I am not finding it in my reference

book.
Any help would be appreciated.

Example:
strdate = 10/11/2004
I need:
strdate +1 = 11/12/2004