Inserting Current Date in Excel 2000
 

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

Inserting Current Date in Excel 2000
 

You can use a function built into excel:

=today()



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

Inserting Current Date in Excel 2000
 

Thanks! I really appreciate your help!

"Dave Peterson" wrote:

You can use a function built into excel:

=today()



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

Inserting Current Date in Excel 2000
 

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!

Inserting Current Date in Excel 2000
 

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