2

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...)

example

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

2
  • You may set date format for cell, but cell contains text not date value. Check date once more – Oleg_S Feb 17 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. – marikamitsos Feb 19 at 14:38
0

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.