I have had this kind of problem before and just don't understand the
problem.  I have a couple of input cells that are date formatted.  Then, I
have a bunch of hlookup functions that find that date in a row of dates and
read down N rows to find a value.  I am getting N/A's right now and cannot
figure out the problem.  All dates have, at least now, the same formatting
(*3/14/2001), so there should be no confusion as to it being a number.  I
have tried other ones such as xx/mm/yyyy, also to no avail.  Sometimes it
seems that, if I start from scratch and rewriter the equations, it fixes
itself.  But this is so much work.

Someone please help!!

Grace
=HLOOKUP($C$18,IndexData!$D$42:$AI$77,Calcs!$S$303,FALSE)