Impressive ..!!
Good show Dave, Siti, STDEV :)
Best Regards,
DILIPandey
On Tue, Dec 28, 2010 at 4:13 PM, Dave Bonallack
<davebonall...@hotmail.com>wrote:
> 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 month Occurrence in no.
> From: villager.g...@gmail.com
> To: excel-macros@googlegroups.com
>
>
> 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 the value 4, remember if i type simply April not 04/01/2010 etc. etc.
>
> please provide your feedback
>
> thanks & regards
>
> ROHAN
> 9818247278, 8860567680
>
>
>
>
> --
>
> ----------------------------------------------------------------------------------
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>
> --
>
> ----------------------------------------------------------------------------------
> Some important links for excel users:
> 1. Follow us on TWITTER for tips tricks and links :
> http://twitter.com/exceldailytip
> 2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
> 3. Excel tutorials at http://www.excel-macros.blogspot.com
> 4. Learn VBA Macros at http://www.quickvba.blogspot.com
> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
>
> To post to this group, send email to excel-macros@googlegroups.com
>
> <><><><><><><><><><><><><><><><><><><><><><>
> Like our page on facebook , Just follow below link
> http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
>
--
Thanks & Regards,
DILIP KUMAR PANDEY
MBA-HR,B.Com(Hons),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 62, India
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our LinkedIN group @ http://www.linkedin.com/groups?gid=1871310
3. Excel tutorials at http://www.excel-macros.blogspot.com
4. Learn VBA Macros at http://www.quickvba.blogspot.com
5. Excel Tips and Tricks at http://exceldailytip.blogspot.com
To post to this group, send email to excel-macros@googlegroups.com
<><><><><><><><><><><><><><><><><><><><><><>
Like our page on facebook , Just follow below link
http://www.facebook.com/pages/discussexcelcom/160307843985936?v=wall&ref=ts
