How to auto-populate days between last day entered in column and today's date.
Our take
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]
Read on the original site
Open the publisher's page for the full experience
Related Articles
- Conditional formatting date help neededI've been trying to use conditional formatting to help automate my work spreadsheet and the date formulas truly escape me. I feel like TODAY is a meany who likes to stick their tongue out at you and point for being stupid XD. This is a spreadsheet with a schedule on it. I am trying to get it to automatically grey out the text when the date passes so I can sort and filter by color and always keep the next upcoming appointment slot be top of the list, while still keeping the data in this sheet because another sheet refers to it via XLOOKUP. https://preview.redd.it/z1jqata8w6xg1.png?width=364&format=png&auto=webp&s=d49f71c8de80c402de1af923fc87e3371d606cc8 Here's the formula I'm using =AND($B$2<TODAY(), $D$2<> "") Column D is client names, for privacy purposes I didn't copy that. They end at D11, if it matters. I'm not sure why excel is treating the dates in May as if they are less than today, when they're not. Does anyone have any ideas? submitted by /u/tashykat [link] [comments]
- Is there an easy way to auto-add multiple rows with the same data in a spreadsheet?We have a tracking spreadsheet that we update twice a year. On the spreadsheet, there are repeating lines of 6/15/25 and 11/15/25. We need to add in a row with the date 6/15/26 under every single 11/15/25 line (hundreds of them). I was curious if there is some sort of formula or way to add all of these rows with the date all at once. The spreadsheet follows a pattern so the 6/15/26 line would always follow the 11/15/25 row and always be every third line in the data set. If not, I might just be adding and copying/pasting for a while but thought I’d see if there’s a trick anyone knew of. submitted by /u/GroundbreakingBath40 [link] [comments]
- Countifs function comparing the number of occurrences of a value within a date range without having to change the date for every cell?https://preview.redd.it/5wv7p6qq6dvg1.png?width=1523&format=png&auto=webp&s=8678f87180d0cf5c410d2f14fdaefc77ca4dc255 I am a self-taught excel newbie and am trying to help automate the calculation of the stats at my job (meaning I will likely be back with multiple more questions). For this problem, I am trying to get the data to automatically calculate as information is entered in another sheet to determine how often certain values (e.g. "Academic") appear within each month. For some reason, when I put the cell (H2) in place of the date, excel does not register it as a cell and will not complete the calculation. The only solution I have found is to have to individually type out each date range rather than referring to the cell that contains the date range. Further, is there a way to not have to include the year? in this job, we have a separate file for every school year meaning there will be no overlap of month causing issues that way. I am trying to find an easier way to do a year to year comparison without having to include helper columns with the beginning and end dates of each month per year. https://preview.redd.it/55l3ixa49dvg1.png?width=1140&format=png&auto=webp&s=3b222fe0266778a2645f72fed52b59efae4ed850 Thank you! submitted by /u/mentallylost14 [link] [comments]
- Formatting question for automating data entryIm going to try to articulate what I need and if it’s possible to do inside excel. At my job I have to record the amount of patrons using our facilities. and specify what particular services are being used. at the end of each quarter. (3 month period) I must tally up all the numbers and provide a total for each aspect of our facility as well as the total overall. For example. 1st quarter numbers. 100 patrons used theatre. 250 patrons used Game room 450 patrons used computer lab so on and so forth. Now that you have the gist in your head. Imagine a spreadsheet where the first form is just a data entry sheet. it’s essentially just a box that never changes. You input the numbers for the week, and that data gets automatically moved to a different cell that has the total amount. so that at the end of the quarter I can easily see my total without having to backtrack or tediously add. if anyone has some insight on how I can do this Please reach out. If you have any questions about my wording or understanding exactly what I mean please also reach out. If you read all this I appreciate your time. submitted by /u/Beneficial-Yard-9006 [link] [comments]