I have a list of date in A3:A13 and 1 date in C1
All dates are formatted as dd/mm/yyy
I try to countif as follow:
=COUNTIF(A3:A13,"<="&C1)
it is OK
but try with VBA:
it returns wrong resultPlease Login or Register to view this content.
See attachment.
Anybody can help?
Bookmarks