A column will depend in B column
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!
|