Difference System date and Excel Date function

  • Thread starter Thread starter Khalil
  • Start date Start date
K

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,
 
See responses to your duplicate posting in the same group, just 6 minutes
earlier.


----- original message -----
 
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.
 
Back
Top