Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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, |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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, |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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, |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Date Difference - Networkdays function not working | Excel Discussion (Misc queries) | |||
Difference betwen Excel Date () Function and System Date | Excel Worksheet Functions | |||
How can I change Excel to use the British date system? | Excel Discussion (Misc queries) | |||
Calculating Difference Between Start Date & Time And End Date & Ti | Excel Discussion (Misc queries) | |||
What is the "system date" in Excel? | Excel Worksheet Functions |