if statement with date

[JJ]

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.

 

[Sheeloo]

Change Col B to date from what, blank?

Try
=IF(B1>0,"a","t")

in A1

 

[Jacob Skaria]

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