Display Time

[Peter1973]

Does anyone know if it is possible to display the current time & date in an excel sheet so when sheets get printed off the time / date is shown.

Thanks

 

[onlyadrafter]

Hello,

=now()

 

[Datsmart]

There are Date and Time selections in Headers or Footers that allow that.
Would that work for you?

 

[erik.van.geit]

Hi, Peter,

other option
you can put the date & time in header or footer

kind regards,
Erik

 

[Peter1973]

Excellent thanx

 

[Peter1973]

One more when I do this the date and time is static is there any way of it updating itself so in fact I have a clock in the sheet ?

 

[Datsmart]

The suggestions given for Header and Footer Date and Times are not static. The suggestion for using NOW() will change each time the workbook is opened, so none of them are truely static.

 

[Peter1973]

Thanks