ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Increment a Variable Defined Date by 1 day (https://www.excelbanter.com/excel-programming/313205-increment-variable-defined-date-1-day.html)

Jimi

Increment a Variable Defined Date by 1 day
 
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

Bob Phillips[_6_]

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




Jimi

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






All times are GMT +1. The time now is 02:49 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com