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

Shane Devenshire wrote:

Hi,

You can also use

=NOW()

and format it to show just the date portion.

--
If this helps, please click the Yes button.

Cheers,
Shane Devenshire

"mayacoleman" wrote:

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

--

Dave Peterson