You can also format the cell
Regards - Dave
On 09/05/2011, at 9:17 AM, "STDEV(i)" wrote:
> Unfortunately Month Function returns Month Index ( 1 to 12 ) not Month NAME
> Assuming A1 containts date data : 12/31/2011
> Formula in B1 =MONTH(A1) returns : 12 not "December"
>
> In vba y
Unfortunately *Month Function* returns *Month Index ( 1 to 12 )* not *Month
NAME*
Assuming A1 containts date data : 12/31/2011
Formula in B1 =MONTH(A1) returns : *12* not *"December"*
In vba you can used MonthName Function
Sub AboutMonth()
Range("B1") = Month(Range("A1"))
Range("C1")
Use Month formula
open excel and copy this in A1
04-04-2011 =month(A1)
Thanks
Nishant
On Sun, May 8, 2011 at 4:48 PM, Rajesh K R wrote:
> Hi Experts
> If I want to get the name of month from dates
> 1/4/11- April
> 5/5/11 - May
>
> how I can I do it with a formula or code
>
> Regards
assuming your date is in cell A2; also try this formula
=TEXT(A2,"[$-6000446]")
Punjabi month name ??
On Sun, May 8, 2011 at 6:18 PM, Rajesh K R wrote:
> Hi Experts
> If I want to get the name of month from dates
> 1/4/11 - April
> 5/5/11 - May
>
> how I can I do it with a formula o
Use formula
=text(ref,"Mmmm")
Where ref is cell reference.
BR//
-Original Message-
From: Rajesh K R
Sender: excel-macros@googlegroups.com
Date: Sun, 8 May 2011 16:48:36
To: excel-macros
Reply-To: excel-macros@googlegroups.com
Subject: $$Excel-Macros$$ get name of months fro
Hi
Thanks for the formula .
Regards
Rajesh Kainikkara
On 5/8/11, ashish koul wrote:
> =TEXT(a1,"")
>
> On Sun, May 8, 2011 at 4:48 PM, Rajesh K R
> wrote:
>
>> Hi Experts
>> If I want to get the name of month from dates
>> 1/4/11- April
>> 5/5/11 - May
>>
>> how I can I do it with
=TEXT(a1,"")
On Sun, May 8, 2011 at 4:48 PM, Rajesh K R wrote:
> Hi Experts
> If I want to get the name of month from dates
> 1/4/11- April
> 5/5/11 - May
>
> how I can I do it with a formula or code
>
> Regards
>
> Rajesh Kainikkara
>
> --
>
>
Hi Experts
If I want to get the name of month from dates
1/4/11- April
5/5/11 - May
how I can I do it with a formula or code
Regards
Rajesh Kainikkara
--
--
Some important links for excel users:
1. Follow u
