How to format the month of date

  • Thread starter Thread starter Guest
  • Start date Start 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"
 
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
 
dim myDate as date
dim myMonthStr as string
'something that gets mydate from the user.
mymonthstr = format(mydate,"mmmm")


If I understand correctly.
 
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
Finding Date in an overseas format 20
excel date format problem 1
convert first 6 digits into date 22
Date formatting 1
VBA in Excel 2007 date formatting 2
Pasting a date to a cell from UserForm 2

Back
Top