How to auto-populate days between last day entered in column and today's date.
I'm going to try my best to explain this with words and samples of my data/spreadsheet.
I'm a wannabe author, and I love keeping track of how many words I've written per day. I used to use NaNoWriMo to keep track of all that, but they went under last year. Thankfully I'd moved all of my daily data into a spreadsheet I made a year ago. But now that I'm getting back into writing, I want to make some changes to the spreadsheet.
This first image is a sample of the most recent dates I'd built into the spreadsheet and is the source of my main frustration. As it is right now, I have to manually drag down the formulas until I hit today's date (whatever the date is when I need to open the spreadsheet and update it). I'm much busier in life now, so there's often several days between writing days. Is there a way to have the spreadsheet automatically populate the rows with all the days between the last day in the spreadsheet and today's date?
For example, let's say today is 5/21/2025 and I open the spreadsheet. What I want is for the table to automatically expand so that A416 has the date 05/20/2025 in it and A417 has the date 05/21/2025 in it. And the rest of the rows have the corresponding data as well. I'm sure this would require macros or VBA or whatever, which I've dabbled in before. Assuming it is even possible.
Also, a minor issue I'm less worried about: I have these graphs in the second image that were inspired by what NaNoWriMo used to do for me. But for some reason, only the daily word counts graph updates to the most recent date in the table when I refresh the data. The total word count graph is stuck with the end of the x-axis being the day I created the spreadsheet (4/2/2025).
[link] [comments]
Want to read more?
Check out the full article on the original site