Learn Excel Now

Conquer the Fear of Excel

Keep up to date on all the newest live trainings, events, and tutorials.

  • Home
  • Training
    • Live Training
    • eLearning
    • On-Demand Training
  • All-Access
  • Resources
  • Library
  • Contact

Excel Date Calculations Part 2: Setting Sequential Dates

December 21, 2016 by Tyrone Pernsley

Excel offers a variety of ways to perform date calculations. In part 1 of this series, we showed you how to find the difference between dates. In this week’s post, we cover setting sequential dates in Excel.

Sheryl is getting ready to perform her annual budget. Her job pays her every two weeks. As a result, 10 months of the year, she receives two paychecks, but there are two months where she ends up with three paychecks. She wants to find each payday in the upcoming year and highlight the months where she will receive three checks.

She starts off with her current payday date:

excel-date-calculations-2

To find the two week pay schedule dates she will:

  • Enter the formula =A2+14
  • This yields the next pay day
  • Then copy the formula across to find all dates
  • Then look for the date with three in a month and highlight them

excel-date-calculations-2

In the example, we see that Excel automatically finds the date 14 days from the original date input. In copying the formula across it populates each date two weeks apart.

We at Learn Excel Now hope you now feel confident setting sequential dates in Excel. This process can be used for a variety of business and personal situations.

Like Learn Excel Now? Follow us on social media and share our content with your networks! And don’t forget to sign up for the Newsletter

Kevin – Learn Excel Now

Filed Under: Formulas & Functions Tagged With: date, Excel 2013, excel functions, formulas and functions, sequential dates

Keep up to date on all the newest live trainings, events, and tutorials.

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.

Sitemap

  • Home
  • Training
    • Live Training
    • eLearning
    • On-Demand Training
  • All-Access
  • Resources
  • Library
  • Contact

Connect with Us

  • Facebook
  • Linkedin

Contact

Learn Excel Now
questions@learnexcelnow.com
1-800-964-6033
384 Technology Drive
Malvern, PA 19355

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

Copyright © 2020 ­ Learn Excel Now

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