If argument d is 0, the result will repeat the same number, as you're telling Excel not to add any increments between each ...

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.