Kristine has attended:
Excel VBA Intro Intermediate course
Listing of dates
Hi, I am having problems with making a list with dates. I want it to always start from todays date and be in the format YYYYMMDD e.g 20101201 then 20101202, 20101203 down in one column, when it gets to the end of the month, I want it to start on the next month e.g 20110101, 20110102 etc. After the month it is currently in and with one additional month, Iwant it to stop and then skip two rows and continue to only list the month with the format YYYYMM, eg 201012 and 201101, 201102 etc, it can not obmit the zeros. Starting from the current month.
I started with making cases for each month, but the code got sooo long with the adding of the zero for days and months from 1-9 etc...so I was hoping that there was a quick fix and an easy solution to this that I just don't see?
Please help.
RE: Listing of dates
Hi Kristine
Thanks for your post and detail on what you are trying to achieve.
I have managed to review this with a few colleagues and we are of the opinion that to provide further assistance will beyond the scope of this forum.
The next steps would be to review your working files and have one of our training consultants call you to discuss further. We would then be able to identify what work is required and durations.
I will email you directly with my contact details should you wish to take this further.
Regards
Jacob
