Hi,
In VBA:
To put first of month of current date into Cell A2:
Range("A2") = Date - (Day(Date) - 1)
To put current date into Cell B2:
Range("B2") = Date
Hope this helps.
Regards - Dave.
Date: Wed, 14 Apr 2010 14:04:35 +0530
Subject: Re: $$Excel-Macros$$ : How to add the current month Date in the
header
From: nsund...@gmail.com
To: dilipan...@gmail.com
CC: excel-macros@googlegroups.com
Hi Dilipandey,
Thanks for your reply.
But i need this is in VBA coding could you please help me.
In my project at the end of finishing all the formating works i need to enter
date first of the current month to current date.
You have given me the formula
Thanks
Sundarvelan
On Tue, Apr 13, 2010 at 2:39 PM, Dilip Pandey <dilipan...@gmail.com> wrote:
Hi Sundarvelan,
For first of the current month, use following function:-
=DATE(YEAR(TODAY()),MONTH(TODAY()),1)
For current date, use following function:-
=TODAY()
--
Thanks & Regards,
DILIP KUMAR PANDEY
MBA-HR,B.Com(Hons),BCA
Mobile: +91 9810929744
dilipan...@gmail.com
dilipan...@yahoo.com
New Delhi - 62, India
On Tue, Apr 13, 2010 at 1:09 PM, Sundarvelan N <nsund...@gmail.com> wrote:
Hi Group,
Im doing a project in which i need to add date "From" date as first of the
Current month and "To" date should be current date
Please help me in this regard.
Thanks,
N.Sundarvelan
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
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
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 6,800 subscribers worldwide and receive many nice notes about the
learning and support from the group.Let friends and co-workers know they can
subscribe to group at http://groups.google.com/group/excel-macros/subscribe
--
N.Sundarvelan
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
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
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 6,800 subscribers worldwide and receive many nice notes about the
learning and support from the group.Let friends and co-workers know they can
subscribe to group at http://groups.google.com/group/excel-macros/subscribe
_________________________________________________________________
If It Exists, You'll Find it on SEEK. Australia's #1 job site
http://clk.atdmt.com/NMN/go/157639755/direct/01/
--
----------------------------------------------------------------------------------
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our Facebook Group @ http://www.facebook.com/group.php?gid=287779555678
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
<><><><><><><><><><><><><><><><><><><><><><>
HELP US GROW !!
We reach over 6,800 subscribers worldwide and receive many nice notes about the
learning and support from the group.Let friends and co-workers know they can
subscribe to group at http://groups.google.com/group/excel-macros/subscribe
To unsubscribe, reply using "remove me" as the subject.
