Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Contradictory results of DateDiff function
Hello,
Could anyone plz point out that what could be the probable reason for DateDiff function to give different answers for the same set of values. I am using the following: DateDiff ( "s", time1, time2) Here 'time1' is greater than 'time2'. But the DateDiff function sometimes returns a positive value and sometimes a negative value. Thanks in advance, Pallavi |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Contradictory results of DateDiff function
are you really different results for the same values?
From XL/VBA Help: If date1 refers to a later point in time than date2, the DateDiff function returns a negative number. In article , "Pallavi Singh" wrote: Hello, Could anyone plz point out that what could be the probable reason for DateDiff function to give different answers for the same set of values. I am using the following: DateDiff ( "s", time1, time2) Here 'time1' is greater than 'time2'. But the DateDiff function sometimes returns a positive value and sometimes a negative value. Thanks in advance, Pallavi |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Contradictory results of DateDiff function
Hello,
Sorry for wasting your time, it was a silly mistake. The dates were different. Thanks P "JE McGimpsey" wrote in message ... are you really different results for the same values? From XL/VBA Help: If date1 refers to a later point in time than date2, the DateDiff function returns a negative number. In article , "Pallavi Singh" wrote: Hello, Could anyone plz point out that what could be the probable reason for DateDiff function to give different answers for the same set of values. I am using the following: DateDiff ( "s", time1, time2) Here 'time1' is greater than 'time2'. But the DateDiff function sometimes returns a positive value and sometimes a negative value. Thanks in advance, Pallavi |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
"DATEDIFF" LOCATION IN EXCEL 2007 | Excel Worksheet Functions | |||
how do you write format results of a function within a function? | Excel Worksheet Functions | |||
Where is DateDiff function in Excel 2002 ? | Excel Worksheet Functions | |||
Application.WorkSheetFunction.DafeDif (not DateDiff) | Excel Programming | |||
DateDiff problem | Excel Programming |