software

Is there a function to convert the text name of a month (e.g., quot;Aprilquot;) to
its corresponding number (e.g., quot;4quot;)? If not, the only workaround I can
think of would be a long, nested IF function (e.g., =IF(A1=quot;Januaryquot;,
quot;1quot;,IF(A1=quot;Februaryquot;, quot;2quot;, . . . etc. . . ))))))))

TIA for any help offered,
Steve

You're welcome.
--
Kevin Vaughnquot;Steve Vincentquot; wrote:

gt; Perfect! Thanks Kevin!
gt; Steve
gt;
gt; quot;Kevin Vaughnquot; wrote:
gt;
gt; gt; With April in B18, this worked for me:
gt; gt; =MONTH(DATEVALUE(B18 amp; quot; 1, 2006quot;))
gt; gt; --
gt; gt; Kevin Vaughn
gt; gt;
gt; gt;
gt; gt; quot;Steve Vincentquot; wrote:
gt; gt;
gt; gt; gt; Is there a function to convert the text name of a month (e.g., quot;Aprilquot;) to
gt; gt; gt; its corresponding number (e.g., quot;4quot;)? If not, the only workaround I can
gt; gt; gt; think of would be a long, nested IF function (e.g., =IF(A1=quot;Januaryquot;,
gt; gt; gt; quot;1quot;,IF(A1=quot;Februaryquot;, quot;2quot;, . . . etc. . . ))))))))
gt; gt; gt;
gt; gt; gt; TIA for any help offered,
gt; gt; gt; Steve

Does anoyone know how to do the reverse. Convert month number to text.

Ex: 1 = Jan, 2= Feb

quot;Steve Vincentquot; wrote:

gt; Is there a function to convert the text name of a month (e.g., quot;Aprilquot;) to
gt; its corresponding number (e.g., quot;4quot;)? If not, the only workaround I can
gt; think of would be a long, nested IF function (e.g., =IF(A1=quot;Januaryquot;,
gt; quot;1quot;,IF(A1=quot;Februaryquot;, quot;2quot;, . . . etc. . . ))))))))
gt;
gt; TIA for any help offered,
gt; Steve

There is no built in conversion either way but it is easy to make one

=VLOOKUP(A1,{1,quot;Janquot;;2,quot;Febquot;;3,quot;Marquot;;4,quot;Aprquot;;5,quot;Ma yquot;;6,quot;Junquot;;7,quot;Julquot;;8,quot;Augquot;;9,quot;Sepquot;;10,quot;Octquot;;11,quot;No vquot;;12,quot;Decquot;},2,0)with your number in A1

You might want to wrap it in an IF function in case a1 is blank

=IF(A1=quot;quot;,quot;quot;,VLOOKUP(A1,{1,quot;Janquot;;2,quot;Febquot;;3,quot;Marquot;;4 ,quot;Aprquot;;5,quot;Mayquot;;6,quot;Junquot;;7,quot;Julquot;;8,quot;Augquot;;9,quot;Sepquot;;10, quot;Octquot;;11,quot;Novquot;;12,quot;Decquot;},2,0))
--
Regards,

Peo Sjoblom
quot;Jennniferquot; gt; wrote in message
...
gt; Does anoyone know how to do the reverse. Convert month number to text.
gt;
gt; Ex: 1 = Jan, 2= Feb
gt;
gt; quot;Steve Vincentquot; wrote:
gt;
gt;gt; Is there a function to convert the text name of a month (e.g., quot;Aprilquot;)
gt;gt; to
gt;gt; its corresponding number (e.g., quot;4quot;)? If not, the only workaround I can
gt;gt; think of would be a long, nested IF function (e.g., =IF(A1=quot;Januaryquot;,
gt;gt; quot;1quot;,IF(A1=quot;Februaryquot;, quot;2quot;, . . . etc. . . ))))))))
gt;gt;
gt;gt; TIA for any help offered,
gt;gt; Steve
=text(date(2007,a1,1),quot;mmmquot;)

if A1 contained the number (1-12).

Jennnifer wrote:
gt;
gt; Does anoyone know how to do the reverse. Convert month number to text.
gt;
gt; Ex: 1 = Jan, 2= Feb
gt;
gt; quot;Steve Vincentquot; wrote:
gt;
gt; gt; Is there a function to convert the text name of a month (e.g., quot;Aprilquot;) to
gt; gt; its corresponding number (e.g., quot;4quot;)? If not, the only workaround I can
gt; gt; think of would be a long, nested IF function (e.g., =IF(A1=quot;Januaryquot;,
gt; gt; quot;1quot;,IF(A1=quot;Februaryquot;, quot;2quot;, . . . etc. . . ))))))))
gt; gt;
gt; gt; TIA for any help offered,
gt; gt; Steve

--

Dave Peterson

Thanks Dave!

quot;Dave Petersonquot; wrote:

gt; =text(date(2007,a1,1),quot;mmmquot;)
gt;
gt; if A1 contained the number (1-12).
gt;
gt; Jennnifer wrote:
gt; gt;
gt; gt; Does anoyone know how to do the reverse. Convert month number to text.
gt; gt;
gt; gt; Ex: 1 = Jan, 2= Feb
gt; gt;
gt; gt; quot;Steve Vincentquot; wrote:
gt; gt;
gt; gt; gt; Is there a function to convert the text name of a month (e.g., quot;Aprilquot;) to
gt; gt; gt; its corresponding number (e.g., quot;4quot;)? If not, the only workaround I can
gt; gt; gt; think of would be a long, nested IF function (e.g., =IF(A1=quot;Januaryquot;,
gt; gt; gt; quot;1quot;,IF(A1=quot;Februaryquot;, quot;2quot;, . . . etc. . . ))))))))
gt; gt; gt;
gt; gt; gt; TIA for any help offered,
gt; gt; gt; Steve
gt;
gt; --
gt;
gt; Dave Peterson
gt;