Autofill Date Weekly With Formula
To fill date weekly, you can apply a simple formula.
1. Select a cell and type the start date. In our case, we type 3/1/2016 in Cell A1. See screenshot:
2. Then in the next cell, A2, type this formula =A1+7, and press Enter key to get the second date. See screenshot:
And now you can drag the Cell A2’s autofill handle down to fill dates weekly as you need. See screenshot:
