sistinechapel

=DAYS360(A1,B1)
happy_gemini 發表於 2012-11-2 16:25

呢個好似係唔準??  google過, 佢當個個月都係得30 日.

反而樓上ching 過果個 datevalue("<<date>>")   return 出黎應該  一相減就係我要ge 數.
不過係食唔到, 唔知點解...  儲存格格式  通用  同日期都試過.  唔得.   甚至好似ching 咁打  "=datevalue"31/1/012""  都一樣唔得.

cl

回復 8# sistinechapel

datevalue() function only works on text value. May be you should try convert
the cell to text by using =text(a1,"d/m/yyyy") before using datevalue().

cl

回復 8# sistinechapel


By the way, what is your meaning of 食唔到? Do you mean, you must input in the format
yyyy/mm/dd but you want to input in, say, dd/mm/yyyy? If yes, then it is a problem of
locale which can be changed in control panel.

sistinechapel

回復  sistinechapel

datevalue() function only works on text value. May be you should try convert
t ...
cl 發表於 2012-11-2 16:43

一樣唔得.  

Kobukuro

deleted

cl

回復 14# sistinechapel

Try datevalue("1/31/2012")

sistinechapel

一樣唔得.
sistinechapel 發表於 2012-11-2 16:52

#value!  <---  到底咩事???  到依家咩 function 都食唔到...  


NETWORKDAYS  同  datevalue 都係咁

sistinechapel

回復  sistinechapel

Try datevalue("1/31/2012")
cl 發表於 2012-11-2 17:44

一樣唔得

Kobukuro

Sorry, networkdays 似乎唔啱你情況!!

應該用datedif
http://spreadsheets.about.com/od ... erence-function.htm

我用你#1 兩個日期試過 OK

IF
A1 = 1/10/2009
B1 = 3/11/2009
Result cell = DATEDIF (A1, B1, "D")

andywong623

Format Cell果度改個cell type做
d/m/yyyy得唔得?