I want to add the date to a spreadsheet where it will change every day that I
open it up. Is this possible and if so how. PLEASE HELP

In a cell:

=TODAY()

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

"Nikki Q" wrote in message ...
|I want to add the date to a spreadsheet where it will change every day that I
| open it up. Is this possible and if so how. PLEASE HELP

Select an un-used cell and enter:
=TODAY()
--
Gary''s Student


"Nikki Q" wrote:

I want to add the date to a spreadsheet where it will change every day that I
open it up. Is this possible and if so how. PLEASE HELP

Use the today() function and format the cell to display as a date

Note: this will update every time you recalculate the sheet. If you want a
static date, select the cell where you want it to display and press Ctrl-;
(control and semicolon)

(from previous reply by Duke Carey to a similar posting today )


"Nikki Q" wrote:

I want to add the date to a spreadsheet where it will change every day that I
open it up. Is this possible and if so how. PLEASE HELP

Hi,

you can use formula =NOW() in a cell. If you want date displayed in specific
format, then just format the cell as you want (for example mm/dd/yyyy,
dd.mm.yyyy h:mm to display also time...).

Regards,
Nika Lampe

"Nikki Q" je napisal:

I want to add the date to a spreadsheet where it will change every day that I
open it up. Is this possible and if so how. PLEASE HELP

In any cell enter =TODAY() for date.

=NOW() for date and time.


Gord Dibben MS Excel MVP

On Thu, 3 Aug 2006 12:46:01 -0700, Nikki Q
wrote:

I want to add the date to a spreadsheet where it will change every day that I
open it up. Is this possible and if so how. PLEASE HELP