Hi,
VBA code for yesterday's date is:
A = Date - 1
The variable 'A' will contain yesterday's date.
Regards - Dave
Date: Tue, 25 May 2010 12:08:06 +0530
Subject: $$Excel-Macros$$ Excel macro Help : Date of Previous day
From: nsund...@gmail.com
To: excel-macros@googlegr
Hi,
I want to learn macros step by step. Please guide me.
Regards
Rakhee
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitter.com/exceldailytip
2. Join our
use the following formula to get only the date.
=TODAY()-1
Regards,
Putta Madaiah
On Tue, May 25, 2010 at 1:15 PM, Swapnil Palande wrote:
> Hi Sundarvelan,
>
> There is no need to write vba code for this.
>
> Use following function:
> =NOW()-1 //This will return date and time ex.: 5/24/2010 13:11
Hi Sundarvelan,
There is no need to write vba code for this.
Use following function:
=NOW()-1 //This will return date and time ex.: 5/24/2010 13:11
=DATE(YEAR(NOW()), MONTH(NOW()), DAY(NOW())-1) // this will return only date
ex: 5/24/2010
Regards,
Swapnil.
On Tue, May 25, 2010 at 12:08 PM, Su
Hi Friends,
Please give the VBA code to find the date of previous day (yesterday).
Thanks,
N.Sundarvelan
--
--
Some important links for excel users:
1. Follow us on TWITTER for tips tricks and links :
http://twitte
