How to populate sequential dates in Excel

How to populate sequential dates in Excel

If you are like me, you love making spreadsheets for almost any solution. I especially like making spreadsheets to track progress on projects. Weight loss goals? Marathon training? Social media metrics? Yeah. Spreadsheets are awesome.

When creating your progress calendar, how do you get a whole year’s worth of Mondays inputted into your sheet? A rookie mistake is to input data line by line when there is a perfectly acceptable way to create rows and rows of sequential data with a simple formula.

#1 Rule of Excel: There is pretty much ALWAYS a way to get it done with a formula.

Here’s how to populate sequential dates in Excel for a day, month, year, or even a whole decade’s worth of rows:

You can add (or subtract) any combination of days, months, and/or years to the initial date, by editing this formula: Continue reading “How to populate sequential dates in Excel”

Enjoy WordPress tinkering? Subscribe for free tips, tricks, and plugin discounts.