View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips[_6_] Bob Phillips[_6_] is offline
external usenet poster
 
Posts: 11,272
Default Increment a Variable Defined Date by 1 day

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