Tags: date, defined, excel, increment, microsoft, msdn, ofthe, software, variable, yyyy

Increment a Variable Defined Date by 1 day

On Microsoft » Microsoft Excel

2,027 words with 2 Comments; publish: Fri, 30 May 2008 17:26:00 GMT; (306125.00, « »)

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

All Comments

Leave a comment...

  • 2 Comments
    • 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" <JimI.excel.questionfor.info.discussions.microsoft.com> wrote in message

      news:95B1CF8E-17D6-4CBB-B40A-D7AF6DC22C6F.excel.questionfor.info.microsoft.com...

      > 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

      #1; Fri, 30 May 2008 17:27:00 GMT
    • 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" <JimI.excel.questionfor.info.discussions.microsoft.com> wrote in message

      > news:95B1CF8E-17D6-4CBB-B40A-D7AF6DC22C6F.excel.questionfor.info.microsoft.com...

      > of

      > book.

      >

      >

      #2; Fri, 30 May 2008 17:28:00 GMT