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