[Last Call] Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 238
  • 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
VIDEO: THE CONCERTO CLOUD FOR HEALTHCARE

Modern healthcare requires a modern cloud. View this brief video to understand how the Concerto Cloud for Healthcare can help your organization.

 
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

Independent Software Vendors: We Want Your Opinion

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

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