We’d like to remind Forumites to please avoid political debate on the Forum.
This is to keep it a safe and useful space for MoneySaving discussions. Threads that are – or become – political in nature may be removed in line with the Forum’s rules. Thank you for your understanding.
📨 Have you signed up to the Forum's new Email Digest yet? Get a selection of trending threads sent straight to your inbox daily, weekly or monthly!
The Forum now has a brand new text editor, adding a bunch of handy features to use when creating posts. Read more in our how-to guide
Fill Down in Excel
JohnSwift10
Posts: 545 Forumite
in Techie Stuff
| 21/10/2023 |
| 21/10/2023 |
| 21/10/2023 |
| 21/10/2023 |
| 21/11/2023 |
| 21/11/2023 |
| 21/11/2023 |
| 21/11/2023 |
| 21/12/2023 |
| 21/12/2023 |
| 21/12/2023 |
| 21/12/2023 |
How do I fill down the above so that it repeats every 4 rows as above so that the next four rows are 21/1/2024 then 21/2/2024 and so on?
0
Comments
-
Does each cell have to be in date format?If not, I would use say 3 columns. Column 1 would be a series of 21's, Column 2 would be the month (just copy and paste, and Column 3 would be the year. Then resize the width of each column accordingly to minimise space.Pretty basic I know but maybe that solution would be acceptable?0
-
JohnSwift10 said:
21/10/2023 21/10/2023 21/10/2023 21/10/2023 21/11/2023 21/11/2023 21/11/2023 21/11/2023 21/12/2023 21/12/2023 21/12/2023 21/12/2023
How do I fill down the above so that it repeats every 4 rows as above so that the next four rows are 21/1/2024 then 21/2/2024 and so on?Just enter the first four (identical) dates, then, if the first cell is A1, in the 5th row put =EDATE(A1,1)Copy that formula down as far as you want. You can copy and past the results back onto themselves as values if you don't want to risk them changing later.I’m a Forum Ambassador and I support the Forum Team on the In My Home MoneySaving, Energy and Techie Stuff boards. If you need any help on these boards, do let me know. Please note that Ambassadors are not moderators. Any posts you spot in breach of the Forum Rules should be reported via the report button, or by emailing forumteam@moneysavingexpert.com.
All views are my own and not the official line of MoneySavingExpert.
1
Confirm your email address to Create Threads and Reply
Categories
- All Categories
- 353.5K Banking & Borrowing
- 254.1K Reduce Debt & Boost Income
- 455K Spending & Discounts
- 246.5K Work, Benefits & Business
- 602.9K Mortgages, Homes & Bills
- 178K Life & Family
- 260.5K Travel & Transport
- 1.5M Hobbies & Leisure
- 16K Discuss & Feedback
- 37.7K Read-Only Boards