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 <http://www.excel-macros.blogspot.com/> 4. Learn VBA Macros at http://www.quickvba.blogspot.com <http://www.quickvba.blogspot.com/> 5. Excel Tips and Tricks at http://exceldailytip.blogspot.com <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
