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”