How to format the month of date

G

Guest

I want to format any user enterable date which is "mm/dd/yy" into month as
"mm" but as text. e.g. for 6/6/6 the variable should return "June"
 
G

GregR

Jeni, with a helper column, assuming dates in Column A, in B1, insert
=Text(A1, "mmmm") and copy down. If you want to remove the helper
column, copy Column B and Paste Special/Values over column A. HTH
 
D

Dave Peterson

dim myDate as date
dim myMonthStr as string
'something that gets mydate from the user.
mymonthstr = format(mydate,"mmmm")


If I understand correctly.
 
G

Guest

Thanks Greg it worked

GregR said:
Jeni, with a helper column, assuming dates in Column A, in B1, insert
=Text(A1, "mmmm") and copy down. If you want to remove the helper
column, copy Column B and Paste Special/Values over column A. HTH
Click to expand...
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Vba Date$ 1
System Dates 8
convert first 6 digits into date 22
Finding Date in an overseas format 20
Pasting a date to a cell from UserForm 2
InputBox Date Value 7
VB Date Format 8
Dates converted into text 5

Top