Quote Originally Posted by snb View Post
Do not consider my suggestions as solutions but as suggestions for a method to attain a certain goal.
You are free to adapt the suggestions to your wishes/requirements.

you could simply use this formula:

PHP Code:
=MATCH(A4,B7:B25000,1) 
Snb thank you anyway for the suggestions, I had already discarded the use of the MATCH formula

1) Does not find the required value: >=, but choose the previous.
2) In the case in which the list having two or more dates homogeneous would identify the position of the last value

I thank all of the suggestions received