Change Col B to date from what, blank?

Try
=IF(B10,"a","t")

in A1

-------------------------------------
Pl. click ''''Yes'''' if this was helpful...



"JJ" wrote:

Hi,

I have 2 columns, col_a & col_B. col_b is Date format.

If I change date (Any date) for col_b, col-a is goinging to change the text
from "a" to "t"

How can I do this? thanks.