Autofill Random Dates

New Contributor

PC/ Windows 10 Pro | Microsoft 365 MSO (16.0.13901.20366)


Hello, I was wondering if there was a way to autofill the empty spaces in the "Date Created" column like I have starting from lines 2-73. The dates are completely random within 01/01/2016 to 04/22/2021.

Each date is connected to a specific router so I can't have one date overwrite another or the empty cells a date should belong to.

Any help on this matter is appreciated, thank you.

3 Replies
best response confirmed by ShoopDoop (New Contributor)


Select column A.

Press F5 to display the Go To dialog.

Click Special...

Select Blanks, then click OK.

Note the address of the active cell in the selection -in your sample spreadsheet it is A75.

Enter the formula =A74 (where A74 is the cell above the active cell) and confirm it with Ctrl+Enter.

Nailed it, thank you for your help.


Easiest is with Power Query - query the range and fill down the dates.