Difference System date and Excel Date function
 

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,

Difference System date and Excel Date function
 

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


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

"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,

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,