J JEC8878 New Member Oct 25, 2024 #1 HI all - is there a way of dragging the dates so the copy down correctly - I have a spreadsheet (attached) and i need 4 lines for each date - can i do this any quicker than manually writing them in Attachments EXAMPLE.xlsx 45.8 KB · Views: 9
HI all - is there a way of dragging the dates so the copy down correctly - I have a spreadsheet (attached) and i need 4 lines for each date - can i do this any quicker than manually writing them in
AliGW Well-Known Member Oct 26, 2024 #2 If you have Excel 2021 or newer, get rid of all the manually entered dates in column A and paste this into A2 followed by ENTER: =INT(SEQUENCE(1000,,DATE(2023,8,19),0.25)) Change 1000 to suit however many rows you wish to fill. Attachments JEC8878 EXAMPLE(248) Chandoo SPILL 365 AliGW.xlsx 51.5 KB · Views: 7
If you have Excel 2021 or newer, get rid of all the manually entered dates in column A and paste this into A2 followed by ENTER: =INT(SEQUENCE(1000,,DATE(2023,8,19),0.25)) Change 1000 to suit however many rows you wish to fill.
