search based on format value

[danusko]

HI,
pls. can you help me?
I try create function, which will find based on format value. I mean f.e. when i have in cell function today() it show like 12.01.09. I need compare this date with date, which is create from other function. In my case is it
=VALUE(CONCATENATE("1.";$D$2&".";D3)).

So i want cell A1 (12.01.09 ) search in array (B1:B10), which dates are created from funcion =VALUE(CONCATENATE("1.";$D$2&".";D3)). There is 12.01.09 in B5.

results will move cursor on cell with the same date if there is, or do nothing, if there is not the same date.

Is it possible?

thx

[oldchippy]

Hi,

I've changed mine to =VALUE(CONCATENATE("1/",$D$2&"/",$D$3)) to get it to work

[danusko]

yes...this work perfectly..
thanke you very much

[oldchippy]

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save