If the values in column B are genuine dates, then:

=IF(B1=DATEVALUE("1/1/2010"),"",1)

--
Gary''s Student - gsnu201001


"Trainee" wrote:

My B1 to B100 are dates coming from an array formula (=MIN...)
11-Jan, 28-Jan are examples of outcome in B column.
This is the formula needed please:
If B1 (then I will copy down) IS EQUAL "0-Jan", then A1="blank"
If B1= IS NOT EQUAL "0-Jan", then A1= 1
THANK YOU!