putting date on spreadsheet

N

Nikki Q

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
 
N

Niek Otten

In a cell:

=TODAY()

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

|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
 
T

Toppers

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

Nika Lampe

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:
 
G

Gord Dibben

In any cell enter =TODAY() for date.

=NOW() for date and time.


Gord Dibben MS Excel MVP
 
Top