Forum Discussion
how do i autofill with dates, but have 2 lines with each date? like 02/01/2020 on the 1 & 2 lines
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.
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.
- 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.
that worked so perfectly!! Thank you ever so much Patrick2788
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)))
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))
