Dates

[asdzxc]

date in A3 is later than in A2.
Plse supply code.

[Bob Phillips]

You could use Data Validation with a Custom type and a formula of

=SUMPRODUCT(--($A$2:$A2>=$A4))=0

[asdzxc]

You could use Data Validation with a Custom type and a formula of

=SUMPRODUCT(--($A$2:$A2>=$A4))=0

Thank you for your formula.
As I want to add code to my macro.
vba code rather than Data Validation, plse

[Bob Phillips]

Then we would need to see what your code does to know how to do a test.

[asdzxc]

Then we would need to see what your code does to know how to do a test.

If date in A3 is later than in A2 or If dates in A: alreagy sorted,
go to A6 and fill-down from A6 to A10

[Aussiebear]

asdzxc, you have a habit of using the Quote tags consistently. Only quote if required and simply type your questions, queries or comments without the quote please.