Please see screenshot below. When I dragged on the blue square in highlighted cell, I only get the result below.

I have set correct region in sheet settings. I have set the correct date format in the cells (how do you verify that, it makes no change...)


To set the cell format, I clicked on the column header to select all column rows, then clicked like below screenshot:

enter image description here

  • You may set date format for cell, but cell contains text not date value. Check date once more
    – Oleg_S
    Feb 17, 2021 at 11:03
  • Please remember that you can also contribute to this community that helps you. As per site guidelines when an answer addresses your question, you should accept it and even upvote it so others can benefit as well. Feb 19, 2021 at 14:38

1 Answer 1


How to fill dates by exactly one year by dragging the cell.

Please do the following:

First create the second cell and then select and drag BOTH.

enter image description here

It has been asked before but never answered correctly.

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.