try this =TEXT(NOW(),"MMMM-YYyY")
On Fri, Aug 5, 2011 at 7:14 PM, Ashish Pradhan <ashlyprad...@gmail.com> wrote: > Hello Rajan > > Thanks a lot. It works > > Thanks > > > Ashish Pradhan > > On 8/5/2011 5:44 PM, Rajan_Verma wrote: > > Use this Format : > > mmmm-yyyy > > > > From: excel-macros@googlegroups.com [mailto:excel-macros@googlegroups.com] > On Behalf Of Venkat CV > Sent: Friday, August 05, 2011 5:05 PM > To: excel-macros@googlegroups.com > Cc: ashlyprad...@gmail.com > Subject: Re: $$Excel-Macros$$ Help with =now() > > > > Hi Ashish, > > > > Yes you can Just Type in Custom "As on" mmm yyyy you will get output as > a "As on August 2011" > > > > Best Regards, > > Venkat > > Chennai > > > > > > On Fri, Aug 5, 2011 at 4:53 PM, Ashish Pradhan <ashlyprad...@gmail.com> > wrote: > > Hello Venkat > > Amazing :-) > > Wonder why I couldn't think of it earlier :-) > > Is the second part possible. For eg. In the same cell, I want the cell to > display as "As on August 2011" (Where August 2011 will be obtained using the > now() formula as described earlier and as you have suggested.. > > > Thanks > > > > > > Ashish Pradhan > > On 8/5/2011 4:41 PM, Venkat CV wrote: > > Hi Ashish, > > > > Select Entire row and goto format cells and Type as below mmmYYYY after > type Now() > > > > It will show as u required... > > > > for more please attach sample worksheet... > > > > Best Regards, > > Venkat > > Chennai > > > > On Fri, Aug 5, 2011 at 2:50 PM, Ashish Pradhan <ashlyprad...@gmail.com> > wrote: > > Hello All, > > I am using Excel 2010 version and I need clarification w.r.t =now() > function. > > In one cell, I can use the =now() to get August after formatting the cell > under "Custom" and changing the Type to mmmm > > My query: > > 1. Can I get August 2011 (not just August-11 which can be obtained under > Format Cells -- Date) > 2. In the same cell, I would like to enter "As on =now()" with the same > condition as mentioned above. > > Is this possible? > > -- > Thanks > > > Ashish Pradhan > > -- > ---------------------------------------------------------------------------------- > 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/discussexcel > > > -- > > > > > > -- > ---------------------------------------------------------------------------------- > 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/discussexcel > > -- > ---------------------------------------------------------------------------------- > 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/discussexcel > > > -- > > > > > > > > > > -- > ---------------------------------------------------------------------------------- > 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/discussexcel > > -- > ---------------------------------------------------------------------------------- > 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/discussexcel > > -- > ---------------------------------------------------------------------------------- > 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/discussexcel > -- ......................... -- ---------------------------------------------------------------------------------- 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/discussexcel
