Maybe something along these lines ..

Assuming the dates are in A2 down

Put the specific date in B1: 1-Jan-2002 (say)

Put in B2: =IF(A2<=$B$1,TEXT(A2,"dd-mmm-yy"),A2)
Copy B2 down

Freeze the results in B2 down with an in-place:
copy paste special values ok
--
Rgds
Max
xl 97
---
GMT+8, 1° 22' N 103° 45' E
xdemechanik <atyahoo<dotcom
----
"Bree" wrote in message
...
I am trying to find out if there is a way to find any dates less than a
specific date (1/1/2002), then replace all with text. Any suggestions?
--
Bree