Solved

Autofill pattern of dates

Posted on 2013-05-24
7
185 Views
Last Modified: 2013-05-24
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
Comment
Question by:mr_bungle89
  • 3
  • 3
7 Comments
 
LVL 43

Expert Comment

by:Saqib Husain, Syed
ID: 39195395
Are these entered as dates or as text?
0
 

Author Comment

by:mr_bungle89
ID: 39195399
as text
0
 
LVL 15

Expert Comment

by:David L. Hansen
ID: 39195412
Year.day OR Year.month?
0
Highfive + Dolby Voice = No More Audio Complaints!

Poor audio quality is one of the top reasons people don’t use video conferencing. Get the crispest, clearest audio powered by Dolby Voice in every meeting. Highfive and Dolby Voice deliver the best video conferencing and audio experience for every meeting and every room.

 

Author Comment

by:mr_bungle89
ID: 39195415
sorry year.month
0
 
LVL 43

Expert Comment

by:Saqib Husain, Syed
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

by:mr_bungle89
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

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

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

Featured Post

Threat Intelligence Starter Resources

Integrating threat intelligence can be challenging, and not all companies are ready. These resources can help you build awareness and prepare for defense.

Join & Write a Comment

Drop Down List with Unique/Distinct Values (Part II - ComboBox or ListBox and Data Validation List Bonus!) David Miller (dlmille) Intro This article focuses on delivering unique, sorted lists to list objects (e.g., ComboBox, ListBox) and Dat…
Introduction This Article briefly covers methods of calculating the NPV and IRR variants in Excel as well as the limitations in calculating and interpreting IRR results. Paraphrasing Richard Shockley, author of my favourite finance reference tex…
This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.
This Micro Tutorial will demonstrate how to create pivot charts out of a data set. I also added a drop-down menu which allows to choose from different categories in the data set and the chart will automatically update.

757 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question

Need Help in Real-Time?

Connect with top rated Experts

19 Experts available now in Live!

Get 1:1 Help Now