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
) 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.com
If the word April or *another month
.
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 Bonallack davebonall
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
Exit
other stuff
=MONTH(DATEVALUE(1 A1 2010))
On Tue, Dec 28, 2010 at 3:34 PM, siti Vi villager.g...@gmail.com 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 rohan.j...@gmail.com wrote:
Hi experts,
is there any formula, if i only type in cell April and the other cell
return
Hi,
A shorter version would be:
=MONTH(--(1A1))
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 month
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.com
If the word April