SOLVED

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)
Solution

@ShoopDoop 

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.

@ShoopDoop 

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