*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 <[email protected]>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 <[email protected]>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 [email protected] >> >> <><><><><><><><><><><><><><><><><><><><><><> >> 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 [email protected] > > <><><><><><><><><><><><><><><><><><><><><><> > 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 [email protected] > > <><><><><><><><><><><><><><><><><><><><><><> > 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 [email protected] <><><><><><><><><><><><><><><><><><><><><><> Like our page on facebook , Just follow below link http://www.facebook.com/discussexcel
