• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 240
  • Last Modified:

Autofill pattern of dates

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
mr_bungle89
Asked:
mr_bungle89
  • 3
  • 3
1 Solution
 
Saqib Husain, SyedEngineerCommented:
Are these entered as dates or as text?
0
 
mr_bungle89Author Commented:
as text
0
 
David L. HansenProgrammer AnalystCommented:
Year.day OR Year.month?
0
Upgrade your Question Security!

Your question, your audience. Choose who sees your identity—and your question—with question security.

 
mr_bungle89Author Commented:
sorry year.month
0
 
Saqib Husain, SyedEngineerCommented:
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
 
mr_bungle89Author Commented:
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
 
Saqib Husain, SyedEngineerCommented:
Then try this

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

Featured Post

Free Tool: Path Explorer

An intuitive utility to help find the CSS path to UI elements on a webpage. These paths are used frequently in a variety of front-end development and QA automation tasks.

One of a set of tools we're offering as a way of saying thank you for being a part of the community.

  • 3
  • 3
Tackle projects and never again get stuck behind a technical roadblock.
Join Now