In Excel, Get todays date in a cell

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

In Excel, how do i get the spreadsheet to automatically update a cell entry
to today's date? (i.e., if i open the spreadsheet on 10/5/05, a cell is
programmed to show 10/5/05; if i open it on 10/6/05, the cell shows 10/6/05,
etc.).
 
=Today() Or use =Now() for date and time and format for date
THESE will both show current pc clock settings and updaste with every
calculation cycle
 

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

Calculating interest due on late loan payments 1
Lookup a particular cell in another excel workbook 1
Calculating a week between a range of dates 3
Fals Result in IF Formula 1
Counting Days 5
Conditional Formatting - Dates 2
Excel number entry 3
Dates not consistent 3

Back
Top