Date-stamping

  • Thread starter Thread starter Michael
  • Start date Start date
M

Michael

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.
 
=TODAY()

--
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.
|
|
 
Brilliant. Thanks. One question though; why isn't date stamping available in
the "Tools" or "Insert"?

Best Regards.
 
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

--
Kind regards,

Niek Otten
Microsoft MVP - Excel

| Brilliant. Thanks. One question though; why isn't date stamping available in
| the "Tools" or "Insert"?
|
| Best Regards.
|
| | > =TODAY()
| >
| > --
| > 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.
| > |
| > |
| >
| >
|
|
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Date Time Stamp formatting 5
Series fill in Excel 2003 problem 2
Auto Open Macro of external .txt file based on cell reference 1
date format convert 2
Special converting of string date&time to date format 3
Excel VBA to go to specific sheet & cell in the current workbook not working. 2
Help with formula 3
Constant date in one cell 1

Back
Top