A column will depend in B column

[Trainee]

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!

 

[Gary''s Student]

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

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

 

[Francis]

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

 

[Fred Smith]

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

Regards,
Fred

 

[Trainee]

That did it!
Thanks again Francis

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]

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

 

[T. Valko]

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(B1>0,1,"")

That could even be reduced to:

=IF(B1,1,"")

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