Learn Excel Now

Conquer the Fear of Excel

  • Home
  • Training
    • Excel
    • MS Office
    • Outlook
    • PowerPoint
    • Word
    • OneDrive
    • Google
  • All-Access
  • eLearning
    • Excel Foundations
    • Micro Courses
      • Simply Excel
  • Resources
  • Login

Setting Dates in Excel: Repeating, Consecutive & Custom

May 25, 2016 by Tyrone Pernsley

Ever been frustrated by repeatedly typing in dates in Excel? You know there is a way to make dates appear in order or repeat but you do not have time to test out how to do it. If this is a daily problem for you than you are in the right place! Today we will show you how to repeat, change or make a pattern of dates in an excel spreadsheet with a few clicks!

#12 gif

To create a spreadsheet continuous dates:

  • First enter the date out in the desired cell that will begin your sequence
  • Click on the cell that contains your first date and hold down the bottom right of the cell and drag downward/rightward.

You will notice that the proceeding dates appear once you have released your click! A full calendar, at the click of a button!

To create a spreadsheet with a repeating date:

  • Enter the date out in the desired cell that will begin your sequence
  • in the next cell below/to the right enter =cell that contains the date to be repeated. (If your date is in A1, you would enter =A1 in the proceeding cell).
  • After this is done, hit enter, click the cell and drag the cell down from the bottom right.
  • Notice that this allows for the desired date to be repeated as many times as you like!

Say you want to have the date repeated twice before proceeding to the next date. To create a pattern that you would like your dates to follow, first enter your desired date in a cell. In the next cell, enter =A1 (or whatever the first cell is) and =A2+1 in the next and =A3 in the next. Like this:

A1- 6/03/2015

A2 – =A1
A3 – =A2 + 1
A4 – =A3

Now select cells A3 and A4, click the bottom right of the selection and drag down to your desired range. You will see that now you have the each date repeated twice! Pretty cool right!? Test out some other patterns and try different things out now that you understand this concept!

Follow the GIF above if you are having any issues! It is a good visual for a difficult concept like this!

We hope you found todays quick and easy Excel lesson beneficial. Don’t forget to follow ups on Social Media and subscribe to the blog to get convenient, quick tips like this, and other great Excel training tips so that you can take the fear out of Excel.

Like Learn Excel Now? Sign up for the newsletter!

Kevin, Learn Excel Now

All Access Subscription
Our 1-year all-access subscription provides step-by-step guidance for mastering Microsoft Office applications, with workshops, exercises and quick reference eGuides. It's perfect for anyone that needs to brush up on certain skills or even folks who need to learn the programs - from a beginner’s level.
Excel Foundations
Take the fear out of Excel with this 20 module self-paced training course. You will cover the most essential topics to develop a solid foundation of Excel or a lifetime of mastery.

Learn Excel Now helps you conquer the fear of Excel. By providing self-paced and instructor-led training and free strategies and guides, we leave no Excel mystery unsolved.

  • Home
  • Training
  • All-Access
  • Excel Foundations
  • Resources

Connect with Us

  • Facebook
  • Linkedin

Contact

Learn Excel Now
questions@learnexcelnow.com
1-484-259-7664 or 1-800-964-6033
660 American Ave
Suite 203
King of Prussia, PA 19406

Microsoft® Office Excel® is a registered trademark of the Microsoft Corporation in the United States and other countries. All rights reserved.

Copyright © 2023 ­Learn Excel Now

Terms of Service

Privacy Policy

Copyright © 2023 · News Pro Theme on Genesis Framework · WordPress · Log in

WELCOME BACK!

Enter your username and password below to log in

Forget Your Username or Password?

Reset Password

Lost your password? Please enter your username or email address. You will receive a link to create a new password via email.

Log In