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 th
Hello Dear,
We are not able to understand your problem,what i am getting is ,you
want vba code.u want to fetch interval from now()[End date] and starting date.
Is it ok then reply,so that we can provide you the code.
Hope it Will Help
Happy to help
:)
Prashant Tripathi
On Wed, Apr 14
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
Hello Dear,
Please read and use the following instruction.
Populating Date In Excel
• Populate today's date with the Today function. Type "=TODAY()" in a
blank cell to return today's date. The Now function returns the date
and the time stamp: "=NOW()".
• Step 2
Calculate a future date by enter
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
N
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 link