Setting Dates to Speadsheets!?

[Neo1]

Hello just a question, How can i make the current date appear in a cell
in the spreadsheet so that for any day that I open it..that days date
is displayed in the cell?

Thanks
From John

 

[Shorty]

Hi john,
click on the cell you want the date in and enter
=now()
this will insert the current date and time.
you can edit the way its shown by right clicking on the cell and using
the 'format cell' option. then click on the 'number' tab to select the
formatting you want to show
Good luck
Shorty

 

[Pete_UK]

An alternative is =TODAY(), which only gives you the date, not the
time.

Pete

 

[Neo1]

Thanks but how can i make the date update every minute..so that the date
is up to date?

Thanks
From John

 

[Gord Dibben]

John

Every 60 seconds hit the F9 function key.

You could use VBA to do this for you if necessary.

See Chip Pearson's "OnTime" instruction page.

http://www.cpearson.com/excel/ontime.htm


Gord Dibben MS Excel MVP

 

[Pete_UK]

The date is only going to change once a day, so there is little point
in updating it every 60 seconds !

Pete

 

[Neo1]

What I want to do is basically up date the "Time" every 60 seconds not
the date....


Thanks
From John

 

[Gord Dibben]

John

Format the =NOW() cell to "time" and follow my original suggestion(s)


Gord

What I want to do is basically up date the "Time" every 60 seconds not
the date....


Thanks
From John

Gord Dibben MS Excel MVP