todays date
 

How would I get todays date in an excel spread sheet
--
kaushi

todays date
 

"Kaushi" wrote in message
...
How would I get todays date in an excel spread sheet
--
kaushi


=NOW

todays date
 

=NOW()

Better (just the date, not the time):

=TODAY()

Both will update with every recalculation. If that is not what you requi
CTRL+;

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Gordon" wrote in message
...
"Kaushi" wrote in message
...
How would I get todays date in an excel spread sheet
--
kaushi


=NOW

todays date
 

hello,
use the TODAY formula. Type in the cell the following:
=TODAY()


"Kaushi" wrote:

How would I get todays date in an excel spread sheet
--
kaushi

todays date
 

If you wanted a line of vba for it you could use:
Range("A1").value = Date


--
Simon Lloyd

Regards,
Simon Lloyd
'www.thecodecage.com' (http://www.thecodecage.com)
------------------------------------------------------------------------
Simon Lloyd's Profile: http://www.thecodecage.com/forumz/member.php?userid=1
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=29043