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!

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!

Try this

=IF(MONTH(B1)=1,"",1)
--
Hope this help

Please click the Yes button below if this post have helped in your needs

Thank You

cheers, francis





"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!

To do what you asked for, in A1 you want:
=if(b1=0,"",1)

Regards,
Fred

"Trainee" wrote in message
...
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!

That did it!
Thanks again Francis
"Francis" wrote:

Try this

=IF(MONTH(B1)=1,"",1)
--
Hope this help

Please click the Yes button below if this post have helped in your needs

Thank You

cheers, francis





"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!

It gives me an error in formula, anyways thanks for the answer
see next reply answering the question. TX

"Gary''s Student" wrote:

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!

If you have a "MIN array" formula that returns dates, if no date meets the
MIN array criteria then that formula will return 0. Your date: "0-Jan", is
just a 0 numeric value formatted as Date.

So, it sounds like what you want is something like this:

=IF(B10,1,"")

That could even be reduced to:

=IF(B1,1,"")

But it's probably more intuitive to use the former.

--
Biff
Microsoft Excel MVP


"Trainee" wrote in message
...
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!