Make row that automatically adds newest month + 2 nearest future months

**cudh** · 08-25-2014, 06:44 AM

I have a row with months in the format Jan-14 (01-01-2014), Feb-14 (01-01-2014) and so on, starting from column 3. I want the row to automatically update such that it contains the months from Jan-14 to the present month + two months. That is, since today's date is 25-08-2014, the row should contain the months Jan-14,...., Aug-14 (01-08-2014), Sept-14 (01-09-2014) and Oct-14 (01-10-2014). I have tried to do the following code but it is currently not working. Any suggestions how to make this work?

Please Login or Register  to view this content.

Best regards

Christian Ulrich

**JOHN H. DAVIS** · 08-25-2014, 07:35 AM

Maybe one of these can help:

Please Login or Register  to view this content.

Or

Please Login or Register  to view this content.

The first extends the range you already have.

The second starts from Jan-Oct. on row 5.

**cudh** · 08-25-2014, 08:18 AM

The first code adds the current month + two nearest future month. However, I need the code to add the months conditional of what is already written in the row. Such that e.g. if Aug-14 and Sept-14 are already in the row, it adds Oct-14.

In the second code I get an error (Run time error 5. Invalid procedure call or argument) on the code part:

Please Login or Register  to view this content.

But thanks, I can definitely use parts of the code!

**jindon** · 08-25-2014, 08:33 AM

Simple AutoFill

Please Login or Register  to view this content.

**cudh** · 08-25-2014, 08:40 AM

Thanks. Works like a charm.

Make row that automatically adds newest month + 2 nearest future months

LinkBack

Thread Tools

Rate This Thread

Display

Make row that automatically adds newest month + 2 nearest future months

Re: Make row that automatically adds newest month + 2 nearest future months

Re: Make row that automatically adds newest month + 2 nearest future months

Re: Make row that automatically adds newest month + 2 nearest future months

Re: Make row that automatically adds newest month + 2 nearest future months

Thread Information

Users Browsing this Thread

Similar Threads

select a cell value based on current month & future months not having a value

[SOLVED] Calculate future date to nearest Monday

Automatically format only those month-cells, that are 3 months ahead of chosen month

If columns are months, how to make separate rows for each month?

Counting dates for a the present month but not future months

Tags for this Thread

Bookmarks

Bookmarks

Posting Permissions