Cells in Excel are referred to using relative or absolute references. A formula with relative references changes when the cell's position does.

How to return a sequence of dates in Excel Excel’s fill handle can generate a quick list of dates for you, but the list is static; you must create a new list if your needs change.