worksheet functions with dates
 

I have a wooksheet that you enter the date in one column(07-05-04), then the
vendor in the next column, discription in the next, who's file is is under,
blank column, then price. What I want to do is when i type the date
(07-05-04) it will automaticlly write the month (July) in the empty column.
So if i type (08-02-04) in the next row, it will automaticlly add the word
August in the cell speciified. Is this possible.

Thanks for you help

Hi Michele

You can use this function

=TEXT(A1,"mmm")



--
Regards Ron de Bruin
http://www.rondebruin.nl


"Michele" wrote in message ...
I have a wooksheet that you enter the date in one column(07-05-04), then the
vendor in the next column, discription in the next, who's file is is under,
blank column, then price. What I want to do is when i type the date
(07-05-04) it will automaticlly write the month (July) in the empty column.
So if i type (08-02-04) in the next row, it will automaticlly add the word
August in the cell speciified. Is this possible.

Thanks for you help

right click sheet tabview codecopy/paste this. SAVE
Now if you type a date in col A below row 1 col B will get the month

Private Sub Worksheet_Change(ByVal Target As Range)
If Target.Row < 2 Or Target.Column < 1 Then Exit Sub
If IsDate(Target) Then
Target.Offset(, 1) = Format(Month(Target), "mmmm")
End If
End Sub

--
Don Guillett
SalesAid Software

"Michele" wrote in message
...
I have a wooksheet that you enter the date in one column(07-05-04), then
the
vendor in the next column, discription in the next, who's file is is
under,
blank column, then price. What I want to do is when i type the date
(07-05-04) it will automaticlly write the month (July) in the empty
column.
So if i type (08-02-04) in the next row, it will automaticlly add the word
August in the cell speciified. Is this possible.

Thanks for you help

One way, in the empty column cell put

=IF(A2="","",TEXT(A2,"mmmm"))

replace A2 with whatever date cell reference(s)

Regards,

Peo Sjoblom



"Michele" wrote:

I have a wooksheet that you enter the date in one column(07-05-04), then the
vendor in the next column, discription in the next, who's file is is under,
blank column, then price. What I want to do is when i type the date
(07-05-04) it will automaticlly write the month (July) in the empty column.
So if i type (08-02-04) in the next row, it will automaticlly add the word
August in the cell speciified. Is this possible.

Thanks for you help