Perfect! Thanks Kevin!
Steve
quot;Kevin Vaughnquot; wrote:
gt; With April in B18, this worked for me:
gt; =MONTH(DATEVALUE(B18 amp; quot; 1, 2006quot;))
gt; --
gt; Kevin Vaughn
gt;
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
Also...
=MONTH(A1amp;quot;-0quot;)
with
quot;Decquot; or quot;decemberquot; etc. in A1--
daddylonglegs
------------------------------------------------------------------------
daddylonglegs's Profile: www.excelforum.com/member.php...oamp;userid=30486
View this thread: www.excelforum.com/showthread...hreadid=508427
留言列表
