Listing of dates

Resolved · Urgent Priority · Version 2007

Wed 1 Dec 2010, 15:00 Delegate Kristine said...

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.

Fri 10 Dec 2010, 10:39 Trainer Jacob said...

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

Excel tip:

Copying Values Without Formulas in Excel 2010

If you want to copy the contents of a cell but don't want to copy the formula with it then use the following simple method:

Press Ctrl+C to copy the values in the cell. On the Home tab, click Paste and then click Paste Values.

View all Excel hints and tips

Listing of dates

Listing of dates

RE: Listing of dates

Excel articles

Excel tip:

Copying Values Without Formulas in Excel 2010