View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
David Biddulph[_2_] David Biddulph[_2_] is offline
external usenet poster
 
Posts: 8,651
Default Difference System date and Excel Date function

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.
--
David Biddulph


"Khalil" wrote in message
...
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,