Trying to help out another poster and am stuck with a dilemma.
Dates are not my forte.

I have a date from one sheet stored in a variable:

Dim eDate As String
eDate = Range("A" & Target.Row).Value

MsgBox eDate results in "8/28/03"

Now I need to find that date in column "A" of another sheet.
That part would be easy except for the fact that the dates in
column A are the result of formulas:
The corresponding date 8/28/03 in column A is represented
by the formula ='2003'!A283

How (or is it possible) to search the formulas in column A
where the result of the formula would equal 8/28/03??

I'm actually looking to get the corresponding row number of
where the match is found.

Thanks,
John