s 7
Regards - Dave.
Date: Wed, 29 Dec 2010 12:12:16 +0500
Subject: Re: $$Excel-Macros$$ how to get month Occurrence in no.
From: sajidmansooral...@gmail.com
To: excel-macros@googlegroups.com
Really Impressive!
Let me know how this formula works
On Tue, Dec 28, 2010 at 3:43 PM, Dave Bonallac
o unabbreviated (eg June, November)
> Regards - Dave.
>
> --
> Date: Tue, 28 Dec 2010 15:34:01 +0700
> Subject: Re: $$Excel-Macros$$ how to get month Occurrence in no.
> From: villager.g...@gmail.com
> To: excel-macros@googlegroups.com
>
>
>
Thanks! Not my own though. Learnt it on another group. Happy to pass it on.
Regards - Dave
Date: Tue, 28 Dec 2010 17:44:51 +0530
Subject: Re: $$Excel-Macros$$ how to get month Occurrence in no.
From: dilipan...@gmail.com
To: excel-macros@googlegroups.com
Impressive ..!!
Good show Dave, Siti
(eg Sept) and also unabbreviated (eg June, November)
> Regards - Dave.
>
> --
> Date: Tue, 28 Dec 2010 15:34:01 +0700
> Subject: Re: $$Excel-Macros$$ how to get month Occurrence in no.
> From: villager.g...@gmail.com
> To: excel-macros@googlegroups.co
Hi,
A shorter version would be:
=MONTH(--(1&A1))
This works for 3-lettered abbreviatios (eg Mar, Oct) as well as extended
abbreviations (eg Sept) and also unabbreviated (eg June, November)
Regards - Dave.
Date: Tue, 28 Dec 2010 15:34:01 +0700
Subject: Re: $$Excel-Macros$$ how to get m
other stuff
=MONTH(DATEVALUE("1 "&A1&" 2010"))
On Tue, Dec 28, 2010 at 3:34 PM, siti Vi wrote:
> If the word "April" or *another month name *is type correctly in cell A1
> try this formula in B1
>
> =TEXT(DATEVALUE("1 "&A1&" 2010"),"M")
>
>
>
>
> On Tue, Dec 28, 2010 at 1:56 PM, Rohan Young
If the word "April" or *another month name *is type correctly in cell A1
try this formula in B1
=TEXT(DATEVALUE("1 "&A1&" 2010"),"M")
On Tue, Dec 28, 2010 at 1:56 PM, Rohan Young wrote:
> Hi experts,
>
> is there any formula, if i only type in cell April and the other cell
> return the value
try this..
Function convertMonthName2Number(monthName As String) As Integer
' try to convert month name to actual date type
Dim dtestr As String
dtestr = monthName & "/1/2000"
Dim dte As Date
On Error Resume Next
dte = CDate(dtestr)
If Err.Number <> 0 Then
convertMonthName2Number = -999
Exi
