Excel
鍑芥暟姹囨�伙紙浜岀骇鐗堬級
1
銆?/p>
YEAR
鐢?/p>
閫?/p>
锛?/p>
杩?/p>
鍥?/p>
鏌?/p>
鏃?/p>
鏈?/p>
鐨?/p>
骞?/p>
浠?/p>
銆?/p>
鍏?/p>
缁?/p>
鏋?/p>
涓?/p>
1900
鍒?/p>
9999
涔?/p>
闂?/p>
鐨?/p>
涓�
涓?/p>
鏁?/p>
鏁?/p>
銆?/p>
璇?/p>
娉?/p>
锛?/p>
YEAR (serial_number)
鍙?/p>
鏁?/p>
锛?/p>
Serial_number
鏄?/p>
涓�
涓?/p>
鏃?/p>
鏈?/p>
鍊?/p>
锛屽叾
涓?/p>
鍖?/p>
鍚?/p>
瑕?/p>
鏌?/p>
鎵?/p>
鐨?/p>
骞?/p>
浠?/p>
銆傛棩
鏈?/p>
鏈?/p>
澶?/p>
绉?/p>
杈?/p>
鍏?/p>
鏂?/p>
寮?/p>
锛氬甫
寮?/p>
鍙?/p>
鐨?/p>
鏂?/p>
鏈?/p>
涓?/p>
(
渚?/p>
濡?/p>
"1998/01/30")
瀹?/p>
渚?/p>
锛?/p>
鍏?/p>
寮?/p>
鈥?/p>
=YEAR("2000/8/6")
杩?/p>
鍥?/p>
2000
鈥?/p>
,=YEAR("2003/05/01"
杩?/p>
鍥?/p>
2003
锛?/p>
=YEAR(35825)
杩?/p>
鍥?/p>
1998
銆?/p>
鍙?/p>
濡?/p>
锛?/p>
YEAR(TODAY()
鈥?/p>
YEAR(2008) =
灏?/p>
鏄?/p>
2014-2008=6
锛?/p>
璁?/p>
绠?/p>
骞?/p>
榫?/p>
鐨?/p>
鏃?/p>
鍊?/p>
鐢?/p>
锛?/p>
2
銆?/p>
TODAY
鐢?/p>
閫?/p>
锛?/p>
杩?/p>
鍥?/p>
绯?/p>
缁?/p>
褰?/p>
鍓?/p>
鏃?/p>
鏈?/p>
鐨?/p>
搴?/p>
鍒?/p>
鍙?/p>
銆?/p>
鍙?/p>
鏁?/p>
锛?/p>
鏃?/p>
璇?/p>
娉?/p>
锛?/p>
TODAY ()
瀹?/p>
渚?/p>
锛?/p>
鍏?/p>
寮?/p>
鈥?/p>
=TODAY()
鈥濊繑
鍥?/p>
2014-7-3(
鎵?/p>
琛?/p>
鍏?/p>
寮?/p>
鏃?/p>
鐨?/p>
绯?/p>
缁?/p>
鏃?/p>
闂?/p>
)
銆?/p>
3
銆?/p>
NOW
鐢?/p>
閫?/p>
锛?/p>
杩?/p>
鍥?/p>
褰?/p>
鍓?/p>
鏃?/p>
鏈?/p>
鍜?/p>
鏃?/p>
闂?/p>
鎵�
瀵?/p>
搴?/p>
鐨?/p>
搴?/p>
鍒?/p>
鍙?/p>
銆?/p>
璇?/p>
娉?/p>
锛?/p>
NOW()
鍙?/p>
鏁?/p>
锛?/p>
鏃?/p>