how can i set dates in right order in cells that are not in order?

Fast answers need clear examples.

Post a small Excel sheet (not a picture) showing realistic & representative sample data WITHOUT confidential information (10-20 rows, not thousands...) and some manually calculated results. For a new thread (1st post), scroll to Manage Attachments, otherwise scroll down to GO ADVANCED, click, and then scroll down to MANAGE ATTACHMENTS and click again. Now follow the instructions at the top of that screen.

Assuming your dates mean that you want the dates to be 1 through 4 January, I entered =MAX(B$2:B3)+1 into B4, then copied and pasted into the other cells. Would something like that work for you?

I can't think of a way to do this with autofill. A formula seemed like the easiest way, but you say you don't want to use a formula, either. A macro would be able to do this. You start the macro, have it ask for the starting date, then keep entering dates until you tell it to stop. It's not the kind of macro programming I do, so I will let others step in to provide code if you can use a macro.

In B4 (if those intermediate rows in column D are actually empty...) -->
=$B$2+COUNTA($D$2:D4)-1

* is that sample a true representative of the actual?