Try something like this:

For a list of dates in Cells A1:A100

C2: (some date)
D2: =MATCH(C2,$A$1:$A$100,0)

Does that help?

Regards,
Ron


--
Ron Coderre
------------------------------------------------------------------------
Ron Coderre's Profile: http://www.excelforum.com/member.php...o&userid=21419
View this thread: http://www.excelforum.com/showthread...hreadid=504956