Difference System date and Excel Date function

[Khalil]

Dear Experts:

I am confused to differnece between system date and excel Date ()
function.

Please difference the following:


1... =Date(year, month, day)

2... Simple typing in excel as July 10,2008,

3.. Window system date and Excel Date function

4.. Is there any link between the Date() function and system date,

 

[JoeU2004]

See responses to your duplicate posting in the same group, just 6 minutes
earlier.


----- original message -----

 

[David Biddulph]

If you want today's date (from the computer clock), use =TODAY() if you want
it to update with the new current date when you reopen the file or
recalculate the sheet.
If you want to put the current date into a cell, but for it not to update
subsequently, use Control semi-colon.