To make a date formula change as you drag it , use a relative reference or build the date from a changing number, not a fixed text date. For example, if your start date is in A1, use =A1+1 in the next cell and drag that down; Excel will keep increasing the date by 1 day.

Why it happens

When a formula keeps showing the same date while dragging, it usually means the date is being treated as fixed text or the cell reference is locked with $. Relative references like A1 change as you copy the formula, while absolute references like $A$1 stay the same.

Common fixes

  • Use =A1+1 for a date series.
  • If you want the first cell to stay fixed, anchor only that cell with $, for example =$A$1+1.
  • If your formula uses a date inside DATE(), make the day part depend on ROW() or COLUMN(), so it changes as you drag.
  • Make sure the cell is formatted as a date, otherwise Excel may show a number instead.

Example

If B1 has 1/1/2026, then:

  • B2 = B1+1
  • B3 = B2+1

Dragging B2 down will produce 1/2/2026, 1/3/2026, 1/4/2026, and so on.

If you want a formula-based series

A simple pattern is:

  • =DATE(2026,1,ROW(A1)) for a vertical list.
  • =DATE(2026,1,COLUMN(A1)) for a horizontal list.

Final note

If you paste your exact formula, I can rewrite it so it drags correctly.