Date Function

C

CMarkou

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.
 
J

John Wilson

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.
 
G

GerryK

=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.
 
N

Norman Harker

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
[email protected]
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.
 
Top