Date Function

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

 

[John Wilson]

CMarkou,

Try

=Today()

John

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.

 

[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

function with the current day? so it will change with each
day.

 

[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
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.

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.