Return Date vaule in cell.

[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.

 

[Frank Kabel]

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)!

 

[JulieD]

Hi Simon

=NOW()
=TODAY()

formatted as you wish should give you what you want.

Cheers
JulieD

 

[Peo Sjoblom]

=DATE(2003,04,03)

or you probably meant

=NOW()

format as dd/mm/yy hh:mm

 

[Guest]

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


.

 

[Norman Harker]

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.

 

[Peo Sjoblom]

And entered together separated by a space in the same cell
it will return date and time