M
mayacoleman
I would like to insert the current date so that it is updated every day. Is
this possible in Excel 2000? Thanks!
this possible in Excel 2000? Thanks!
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
Dave Peterson
You can use a function built into excel:
=today()
=today()
M
mayacoleman
Thanks! I really appreciate your help!
Dave Peterson said:You can use a function built into excel:
=today()
S
Shane Devenshire
Hi,
You can also use
=NOW()
and format it to show just the date portion.
You can also use
=NOW()
and format it to show just the date portion.
D
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().
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().