PDA

View Full Version : Dates



asdzxc
05-21-2012, 12:08 AM
date in A3 is later than in A2.
Plse supply code.

Bob Phillips
05-21-2012, 12:16 AM
You could use Data Validation with a Custom type and a formula of

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

asdzxc
05-21-2012, 01:02 AM
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
05-21-2012, 02:13 AM
Then we would need to see what your code does to know how to do a test.

asdzxc
05-21-2012, 02:25 AM
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
05-21-2012, 05:03 AM
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.