Date-stamping

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Michael - 23 Dec 2006 08:49 GMT

How do I put the present date on a cell such as A1 so that any day I open
the file, the correct date is shown.

Thanks in advance.

Reply to this Message

Niek Otten - 23 Dec 2006 10:03 GMT

=TODAY()

Signature

Kind regards,

Niek Otten
Microsoft MVP - Excel

| How do I put the present date on a cell such as A1 so that any day I open
| the file, the correct date is shown.
|
| Thanks in advance.

Reply to this Message

Michael - 23 Dec 2006 10:20 GMT

Brilliant. Thanks. One question though; why isn't date stamping available in
the "Tools" or "Insert"?

Best Regards.

> =TODAY()
>
[quoted text clipped - 8 lines]
> |
> | Thanks in advance.

Reply to this Message

Niek Otten - 23 Dec 2006 10:49 GMT

It's available in Insert>Function.
But if you want the date to remain the same once it's put there, you need to press CTRL+;
=TODAY() will update each time you open or calculate the workbook

Signature

Kind regards,

Niek Otten
Microsoft MVP - Excel

Reply to this Message