Inserting Current Date in Excel 2000

[mayacoleman]

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

 

[Dave Peterson]

You can use a function built into excel:

=today()

 

[mayacoleman]

Thanks! I really appreciate your help!

You can use a function built into excel:

=today()

 

[Shane Devenshire]

Hi,

You can also use

=NOW()

and format it to show just the date portion.

 

[Dave Peterson]

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