Dates?

[lightbulb]

In column J I have dates in the format mm/dd/yy ... then across row 5 I have
monthes in the form month/yy (i.e. Apr-09). If a date in column J reads
05/16/09 , I want to place the certain text in the column corresponding with
May-09 (in the row that reads 05/16/09). Does that make sense? Any help?

 

[Otto Moehrbach]

I'm sure this macro will not do exactly what you want, but try it and come
back with corrections you want. Otto
Sub PlaceCertainText()
Dim rColJ As Range
Dim i As Range
Set rColJ = Range("J6", Range("J" & Rows.Count).End(xlUp))
For Each i In rColJ
Cells(i.Row, Month(i)) = "Certain text"
Next i
End Sub

 

[Bill Kuunders]

=TEXT(J5,"MMM""-""yy")

should work

greetings from New Zealand