Inserting Current Date in Excel 2000

  • Thread starter Thread starter mayacoleman
  • Start date Start date
M

mayacoleman

I would like to insert the current date so that it is updated every day. Is
this possible in Excel 2000? Thanks!
 
Just to add to Shane's response...

You can format the cell to show both the date and time and it'll update as often
as excel recalculates.

But if you use it to compare dates like:
=if(a1=date(2009,12,25), ... )
or
=if(A1=b1, ...)
where A1 contains =now() and B1 contains a date (without the time), then you may
not want to include the time by using =now().
 

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

Excel Vba to change displayed year automatically. 14
Date Field 3
automatic "date update" 3
Can I get date in this format? 1
BUG - Global Format changes Number and Dates 2
How do I do a drop down box with calender in excel? 4
Change Default Auto-Fill-In month 4
'Cannot insert object' message when I try to put a button on a worksheet 7

Back
Top