If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Difference betwen Excel Date () Function and System Date
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 Date function 4.. Is there any link between the Date() function and system date, |
#2
|
|||
|
|||
Difference betwen Excel Date () Function and System Date
"Khalil" wrote:
4.. Is there any link between the Date() function and system date, No. The term "system date" usually refers to the current date. That is returned by the TODAY() function. The DATE() function allows you to form any date value (aka serial number). The is no difference between typing July 10, 2008 and DATE(2008,7,10). However, you cannot use July 10, 2008 directly in an expression. For example, if you want to test if A1 is that date, you cannot write IF(A1="July 10, 2008",...). But you can write IF(A1=DATE(2008,7,10),...). You can also write IF(A1=DATEVALUE("July 10, 2008"),...). ----- original message ----- "Khalil" wrote in message ... 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 Date function 4.. Is there any link between the Date() function and system date, |
#3
|
|||
|
|||
Difference betwen Excel Date () Function and System Date
Khalil
For more on excel dates; refer http://www.cpearson.com/excel/datetime.htm -- If this post helps click Yes --------------- Jacob Skaria "Khalil" wrote: 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 Date function 4.. Is there any link between the Date() function and system date, |
Thread Tools | |
Display Modes | |
|
|