Solved

# Date formula - so months flow in sequence

Posted on 2013-02-07
265 Views
Hi Experts

I have in cell a1 =Text(Now(),"mmmyy") this is fine
Now I want on cell b1 +one month then plus two month in cell c1 etc..

So.   A1.            B1.            C1.
Feb13.       Mar13.     Apr13.

Etc...

How do I change formula
0
Question by:route217
[X]
###### Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

• Help others & share knowledge
• Earn cash & points

LVL 24

Accepted Solution

Steve earned 500 total points
ID: 38863569
use:

=TEXT(DATE(YEAR(NOW()),MONTH(NOW()),1),"mmmyy")

=TEXT(DATE(YEAR(NOW()),MONTH(NOW())+1,1),"mmmyy")

or to increment automatic the following will do the whole range:

=TEXT(DATE(YEAR(NOW()),MONTH(NOW())+COLUMN()-1,1),"mmmyy")
0

LVL 27

Expert Comment

ID: 38863573
Sorry should have refreshed before posting.
0

Author Comment

ID: 38863582
Many thanks Barman
0

## Featured Post

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Introduction While answering a recent question (http:/Q_27311462.html), I created an alternative function to the Excel Concatenate() function that you might find useful.  I tested several solutions and share the results in this article as well as tâ€¦
Freeze panes is an option within all variants of Excel to enable parts of a sheet to remain stationary when the cursor is in another part of the sheet. This is a very useful feature which is overlooked or under used.
This Micro Tutorial will demonstrate on a Mac how to change the sort order for chart legend values and decrpyt the intimidating chart menu.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.
###### Suggested Courses
Course of the Month2 days, 7 hours left to enroll