how do i autofill with dates, but have 2 lines with each date? like 02/01/2020 on the 1 & 2 lines

[kristinapinske]

how do i autofill with dates, but have 2 lines with each date? like 02/01/2020 on the 1st line, 02/01/2020 on the second line, 03/01/2020 on the third line, 03/01/2020 on the fourth line....etc.

[#2]

Hello @kristinapinske,

Place 02/01/2020 in cell A1. Place the following formula in cell A2 and copy down:

=IF(MOD(ROW(),2)=0,A1,DATE(YEAR(A1),MONTH(A1)+1,DAY(A1)))

[#3]

@kristinapinske 

Use the fill handle.

1. In a new worksheet go to A1 and enter the date 2/1/2020

2. Right-click and drag the fill handle down as many rows as you need dates.

3. Release the right-click and choose Series from the context menu.

4.  The Series menu should use these choices:

5. Click OK.

[#4]

that worked so perfectly!!  Thank you ever so much @Patrick2788 

[#5]

or this one...

Place 02/01/2020 in cell A1. Place the following formula in cell A2 and copy down:
=IF(MOD(ROW(),2)=0,A1,DATE(YEAR(A1),MONTH(A1),DAY(A1)+1))

[#6]

That is awesome to have found out, thank you! There are many times when I need 2 or 3 copies of the same cell in a long list that has already been generated.