looking for and locate in a cell (Dates)

[jaquete]

Dear Mr Excel, i´d like know how i can the following Macro:
In the A colum i have numbers for the days for one month (1 to 31)
In another cell i have a formula to obtain the number of the day ( i.e. Sep 4=4)
The macro munt go to the cell in A colum that contain the number in the formula.

I tryed with go to, find, but in the macro don´nt change the number to locate.
Thanks in advance

 

[Legacy 98055]

Hi
I do not understand what it is you are trying to accomplish?
Please try again??
Tom