if statement with date
 

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.

if statement with date
 

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.

if statement with date
 

If you would like to use a macro here it is

Private Sub Workbook_SheetChange(ByVal Sh As Object, ByVal Target As Range)
If Target.Column = 2 Then
Cells(Target.Row, 1) = "t"
End If
End Sub

If you are new to macros.Set the Security level to low/medium in
Tools|Macro|Security). 'Launch VBE using short-key Alt+F11. On the left
treeview right click 'This Workbook '. Drop down to get the change event and
paste the below code. Save. Get back to Workbook and try

If this post helps click Yes
---------------
Jacob Skaria


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