Want to win a PS4? Go Premium and enter to win our High-Tech Treats giveaway. Enter to Win

x
Solved

# Autofill pattern of dates

Posted on 2013-05-24
Medium Priority
235 Views
Hi,

I would like to autofill a pattern of dates like below. Can anyone help me with this in excel?

2010.01
2010.01
2010.01
2010.01
2010.02
2010.02
2010.02
2010.02
2010.03
2010.03
2010.03
2010.03
0
Question by:mr_bungle89
[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
• 3
• 3

LVL 43

Expert Comment

ID: 39195395
Are these entered as dates or as text?
0

Author Comment

ID: 39195399
as text
0

LVL 15

Expert Comment

ID: 39195412
Year.day OR Year.month?
0

Author Comment

ID: 39195415
sorry year.month
0

LVL 43

Expert Comment

ID: 39195417
How far do you want to go?

This will simply increment the digits after the decimal.

Enter the first four and then this formula

=LEFT(A2,5)&TEXT(RIGHT(A2,2)+1,"00")
0

Author Comment

ID: 39195429
thanks, but that doesn't work as when it goes past december it adds a '13' 2010.13 and does not go in to the new year.
0

LVL 43

Accepted Solution

Saqib Husain, Syed earned 2000 total points
ID: 39195431
Then try this

=TEXT(DATE(LEFT(A2,4),RIGHT(A2,2)+1,1),"YYYY.MM")
0

## Featured Post

Question has a verified solution.

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

Some code to ensure data integrity when using macros within Excel. Also included code that helps secure your data within an Excel workbook.
After seeing numerous questions for Dynamic Data Validation I notice that most have used Visual Basic to solve the problem. This suggestion is purely formula based and can be used in multiple rows.
This Micro Tutorial will demonstrate how to use longer labels with horizontal bar charts instead of the vertical column chart.
This Micro Tutorial will demonstrate in Microsoft Excel how to add style and sexy appeal to horizontal bar charts.
###### Suggested Courses
Course of the Month10 days, 5 hours left to enroll