Return Date vaule in cell.

  • Thread starter Thread starter Simon
  • Start date Start date
S

Simon

Is there are function that can return the date value eg.
(12/03/04) to a cell?

I also need a fuction for the time as well.

Many Thanks.
 
Hi Simon
to get the current date enter
=TODAY()
and format this cell as date
Note: This cell will change if you open the workbook again tomorrow
(13/03/04)!
 
Hi Simon

=NOW()
=TODAY()

formatted as you wish should give you what you want.

Cheers
JulieD
 
Thanks
-----Original Message-----
Hi Simon
to get the current date enter
=TODAY()
and format this cell as date
Note: This cell will change if you open the workbook again tomorrow
(13/03/04)!

--
Regards
Frank Kabel
Frankfurt, Germany


.
Click to expand...
 
Hi Simon!

You might also like to consider:

Ctrl + ;
Returns the current system date and doesn't update the next day.

Ctrl + :
Returns the current system time and doesn't update.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
 
And entered together separated by a space in the same cell
it will return date and time
 
Back
Top