SOLVED

Autofill Random Dates

%3CLINGO-SUB%20id%3D%22lingo-sub-2282854%22%20slang%3D%22en-US%22%3EAutofill%20Random%20Dates%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2282854%22%20slang%3D%22en-US%22%3E%3CP%3EPC%2F%20Windows%2010%20Pro%20%7C%20Microsoft%20365%20MSO%20(16.0.13901.20366)%3C%2FP%3E%3CP%3E%26nbsp%3B%3C%2FP%3E%3CP%3EHello%2C%20I%20was%20wondering%20if%20there%20was%20a%20way%20to%20autofill%20the%20empty%20spaces%20in%20the%20%22Date%20Created%22%20column%20like%20I%20have%20starting%20from%20lines%202-73.%20The%20dates%20are%20completely%20random%20within%2001%2F01%2F2016%20to%2004%2F22%2F2021.%3C%2FP%3E%3CP%3EEach%20date%20is%20connected%20to%20a%20specific%20router%20so%20I%20can't%20have%20one%20date%20overwrite%20another%20or%20the%20empty%20cells%20a%20date%20should%20belong%20to.%3C%2FP%3E%3CP%3EAny%20help%20on%20this%20matter%20is%20appreciated%2C%20thank%20you.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-LABS%20id%3D%22lingo-labs-2282854%22%20slang%3D%22en-US%22%3E%3CLINGO-LABEL%3EExcel%3C%2FLINGO-LABEL%3E%3CLINGO-LABEL%3EFormulas%20and%20Functions%3C%2FLINGO-LABEL%3E%3C%2FLINGO-LABS%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2283066%22%20slang%3D%22en-US%22%3ERe%3A%20Autofill%20Random%20Dates%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2283066%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1035102%22%20target%3D%22_blank%22%3E%40ShoopDoop%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3EEasiest%20is%20with%20Power%20Query%20-%20query%20the%20range%20and%20fill%20down%20the%20dates.%3C%2FP%3E%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2283056%22%20slang%3D%22en-US%22%3ERe%3A%20Autofill%20Random%20Dates%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2283056%22%20slang%3D%22en-US%22%3ENailed%20it%2C%20thank%20you%20for%20your%20help.%3C%2FLINGO-BODY%3E%3CLINGO-SUB%20id%3D%22lingo-sub-2283053%22%20slang%3D%22en-US%22%3ERe%3A%20Autofill%20Random%20Dates%3C%2FLINGO-SUB%3E%3CLINGO-BODY%20id%3D%22lingo-body-2283053%22%20slang%3D%22en-US%22%3E%3CP%3E%3CA%20href%3D%22https%3A%2F%2Ftechcommunity.microsoft.com%2Ft5%2Fuser%2Fviewprofilepage%2Fuser-id%2F1035102%22%20target%3D%22_blank%22%3E%40ShoopDoop%3C%2FA%3E%26nbsp%3B%3C%2FP%3E%0A%3CP%3ESelect%20column%20A.%3C%2FP%3E%0A%3CP%3EPress%20F5%20to%20display%20the%20Go%20To%20dialog.%3C%2FP%3E%0A%3CP%3EClick%20Special...%3C%2FP%3E%0A%3CP%3ESelect%20Blanks%2C%20then%20click%20OK.%3C%2FP%3E%0A%3CP%3ENote%20the%20address%20of%20the%20active%20cell%20in%20the%20selection%20-in%20your%20sample%20spreadsheet%20it%20is%20A75.%3C%2FP%3E%0A%3CP%3EEnter%20the%20formula%20%3DA74%20(where%20A74%20is%20the%20cell%20above%20the%20active%20cell)%20and%20confirm%20it%20with%20Ctrl%2BEnter.%3C%2FP%3E%3C%2FLINGO-BODY%3E
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.