Date Function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I am trying to find out is there a way to create a cell function with the current day? so it will change with each day.
 
CMarkou,

Try

=Today()

John

CMarkou said:
I am trying to find out is there a way to create a cell function with the
Click to expand...
current day? so it will change with each day.
 
=TODAY() does that. Is this what you mean?
-----Original Message-----
I am trying to find out is there a way to create a cell
Click to expand...
function with the current day? so it will change with each
day.
 
Hi CMarkou!

=TODAY()
Returns today's date and will change on recalculation of the workbook
if the date has changed

=NOW()
Returns the date and time and will change on recalculation of the
workbook.


Just for comparison:
Ctrl + ; <enter> will give you a non-changing date
Ctrl + : <enter> will give you a non-changing time
Ctrl + ; <space> Ctrl + : <enter> will give you a non-changing date
and time
--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.
CMarkou said:
I am trying to find out is there a way to create a cell function
Click to expand...
with the current day? so it will change with each day.
 
Back
Top