Dates just the month?

[apwdweb]

Hi,

I have a column of dates that are in this format:

'01/2004

i'd like to capture just the month element into a variable for comparison purposes. does anyone know the VBA code to capture just the month element of this format?

Thanks

 

[PaddyD]

assuming you've got text entries, not date values:

left(a1,2)

 

[acw]

Hi

This should get you started. It does assume that the month is always 2 characters.

Tony

Sub bbb()
While Not IsEmpty(ActiveCell)

MsgBox Left(ActiveCell, 2)
ActiveCell.Offset(1, 0).Select
Wend
End Sub

 

[apwdweb]

cool i'm not what i've got as far as text or date yet but suppose it is a date format. what would the code be then?

Thanks for your help. I do appreciate your time and efforts.

 

[PaddyD]

=text(a1,"MM")

 

[Aladin Akyurek]

With '01/2004

=MONTH(A1+0)

would also suffice.

 

[apwdweb]

you guys are awesome man thanks for your help.