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

Greg
Jeni wrote:
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"

Thanks Greg it worked

"GregR" wrote:

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

Greg
Jeni wrote:
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, or just use a custom format of mmmm.

Greg
Jeni wrote:
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"

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


If I understand correctly.


Jeni wrote:

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"

--

Dave Peterson