=Text(n,"mmm") always returns "Jan" when n=1..12
Try
=TEXT(date(year(today()),n,1),"mmm")
If this post helps click Yes
---------------
Jacob Skaria
"Blaze-Of-Glory" wrote:
Excel 2007 - Why doesn't this work? Being forced to use VLookup and make a
month table each time I want to convert a month number to a month nme
|