Skip to content
Free Excel Tutorials
  • Home
  • Excel For Beginners
  • Excel Intermediate
  • Advanced Excel For Experts

Data Analysis

  • How to create Checklist in Excel
  • How To Remove Duplicates In Excel Column Or Row?
  • How to conditionally sum numeric data in an Excel table using SUMIFS
  • Understanding Pivot Tables in Excel
  • How to Create Gantt Chart in Excel

References

  • How to use Excel FORMULATEXT function
  • How to calculate two-way lookup VLOOKUP in Excel Table
  • How to use Excel INDIRECT Function
  • Multi-criteria lookup and transpose in Excel
  • Excel Advanced Lookup using Index and Match Functions

Data Validations

  • Excel Data validation don’t exceed total
  • Excel Data validation must contain specific text
  • Prevent invalid data entering in specific cells
  • Excel Data validation number multiple 100
  • Excel Data validation date in specific year

Series of dates by day

by

This tutorials shows how to generates Series of dates increment by day from a single start date in Excel.

If you need to generate a dynamic series of dates with a formula that increase by one day from a single start date, you can do so a very simple formula that simply adds 1 to each date.

Formula

=date+1

Explanation

 

In the example, B6 is the hard-coded start date and the formula in B7 is:

=B6+1

Because dates in Excel are just serial numbers (the first date in the standard Excel date system is January 1, 1900), you can adjust dates just adding or subtracting values. To solve this formula, Excel just adds 1 to the date in B6.  The first formula therefore returns a new date of 1/31/2000, one day later than the starting date.

Once the first formula is entered, it is copied down as far as needed. Each subsequent formula creates a new date incremented by one day. You could easily adjust the formula generate future dates by weeks, by using 7 instead of 1, like so:

=B6+7

Post navigation

Previous Post:

DECIMAL function: Description, Usage, Syntax, Examples and Explanation

Next Post:

AVERAGE function: Description, Usage, Syntax, Examples and Explanation

Leave a Reply Cancel reply

Your email address will not be published. Required fields are marked *

Learn Basic Excel

Ribbon
Workbook
Worksheets
Format Cells
Find & Select
Sort & Filter
Templates
Print
Share
Protect
Keyboard Shortcuts

Categories

  • Charts
  • Data Analysis
  • Data Validation
  • Excel Functions
    • Cube Functions
    • Database Functions
    • Date and Time Functions
    • Engineering Functions
    • Financial Functions
    • Information Functions
    • Logical Functions
    • Lookup and Reference Functions
    • Math and Trig Functions
    • Statistical Functions
    • Text Functions
    • Web Functions
  • Excel VBA
  • Excel Video Tutorials
  • Formatting
  • Grouping
  • Others

Logical Functions

  • XOR function: Description, Usage, Syntax, Examples and Explanation
  • Check multiple cells are equal in Excel
  • IF, AND, OR and NOT Functions Examples in Excel
  • How to use IFS function in Excel
  • IF with boolean logic in Excel

Date Time

  • Calculate retirement date in Excel
  • Get last working day in month in Excel
  • DATEVALUE function: Description, Usage, Syntax, Examples and Explanation
  • Get day from date in Excel
  • Convert Excel time to decimal hours in Excel

Grouping

  • Group numbers with VLOOKUP in Excel
  • Categorize text with keywords in Excel
  • How to randomly assign people to groups in Excel
  • Running count group by n size in Excel
  • Group numbers at uneven intervals in Excel

General

  • How to Insert Cells, Row and Rows in Excel
  • Select, Insert, Rename, Move, Delete Worksheets in Excel
  • Creating and Opening an existing file in Excel
  • Flash Fill in Excel
  • How to test a range for numbers in Excel
© 2026 xlsoffice . All Right Reserved. | Teal Smiles | Abbreviations And Their Meaning