Auto fill row

[Kerikter7787]

I'm new to Excel and I want to fill a row with dates in it I put the first date in A1 and the second date in B1. how can I get the rest of the row filled with sequental dates?

Example I have Jan 1/2021 in A1 and Jan 2/2021 in B1 I want the rest of the row filled with say Jan 3/2021 to Jan 14/2021.

Please give detailed instructions please.

 

[jtakw]

Hi,

Type: 1/1/2021 in A1
Right Click A1, Select Format cells
Select "Custom"
In the "Type" box, enter mmm d/yyyy
Click OK

With A1 selected, left click on Cell Handle (little square at lower right corner)
Drag right as far as you need.