Find the position of a date.

[eduzs]

In column "A" I have texts, values, and one cell with a DATE.
I need to find in which row is there this date.
Is there a formula to do that?
Many thanks

 

[Rick Rothstein]

Rick,
The stock market in Brazil is up. The IBOVESPA (general index as the Dow Jones in US) today stands at more than 70,000 points.
So your formula is a bit risky ...

I specifically followed up your question by asking the OP to "show us actual values that could be in the cells (do not simplify things by using 1, 2, 3, etc. for you numbers unless those are your real numbers)"... the OP responded with a maximum number of 54... since that is significantly lower than 42,991 (todays date serial number), I figured using MAX was safe. If the OP lies to us when we ask for clarification, then that OP will simply get suggestions that do not work (sort of a garbage in, garbage out situation).

 

[eduzs]

(deleted reply)

 

[eduzs]

Solved. Thanks all.

 

[eduzs]

Rick,
The stock market in Brazil is up. The IBOVESPA (general index as the Dow Jones in US) today stands at more than 70,000 points.
So your formula is a bit risky ...

Just kidding.
Of course you could not know that the data refer to stock quotes in Brazil - the text is in Portuguese.

M.

As there's no ISDATE() function and I prefer formula based solution, I got this formula with help from this forum:

=SUMIFS($A$1:$A$1000,$A$1:$A$1000,">"&DATEVALUE("1/1/"&YEAR(NOW())),$A$1:$A$1000,"<="&DATEVALUE("31/12/"&YEAR(NOW())))

Thanks.