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
<mailto: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
<mailto: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
<mailto: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
<mailto: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
<mailto: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
