A column will depend in B column

  • Thread starter Thread starter Trainee
  • Start date Start date
T

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!
 
If the values in column B are genuine dates, then:

=IF(B1=DATEVALUE("1/1/2010"),"",1)
 
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
 
That did it!
Thanks again Francis
Francis said:
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
Click to expand...
 
It gives me an error in formula, anyways thanks for the answer
see next reply answering the question. TX
 
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.
 
Back
Top