Thread: Dates?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Bill Kuunders Bill Kuunders is offline
external usenet poster
 
Posts: 303
Default Dates?

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

should work

greetings from New Zealand

"lightbulb" wrote in message
...
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?