返回列表下一主題上一主題發帖

[發問] 下一個特休推算

av8d

大學生 Rank: 4

帖子: 701
主題: 275
精華: 0
積分: 1002
點名: 1
作業系統: Windows 10
軟體版本: Office 2019
閱讀權限: 50
性別: 男
註冊時間: 2011-6-30
最後登錄: 2024-5-4

1^# 跳轉到 » 倒序看帖

打印

字體大小: tT

發表於 2017-3-10 09:20 | 顯示全部帖子

[發問] 下一個特休推算

本帖最後由 av8d 於 2017-3-10 09:27 編輯

特休推算.rar (9.07 KB)

下一個特休推算
=IF(AND(DATEDIF(C2,H2,"y")=0,DATEDIF(C2,H2,"ym")<6),
IF(AND(DATEDIF(H2,I2,"ym")=0,DATEDIF(H2,I2,"md")<>0),"還有"&DATEDIF(H2,I2,"md")&"天，滿6個月。",
IF(AND(DATEDIF(H2,I2,"ym")<>0,DATEDIF(H2,I2,"md")=0),"還有"&DATEDIF(H2,I2,"ym")&"個月，滿6個月。",
IF(AND(DATEDIF(H2,I2,"ym")<>0,DATEDIF(H2,I2,"md")<>0),"還有"&DATEDIF(H2,I2,"ym")&"個月又"&DATEDIF(H2,I2,"md")&"天，滿6個月。",
IF(AND(DATEDIF(C2,H2,"y")=0,DATEDIF(C2,H2,"ym")>6),
IF(AND(DATEDIF(H2,J2,"ym")=0,DATEDIF(H2,J2,"md")<>0),"還有"&DATEDIF(H2,J2,"md")&"天，滿1年。",
IF(AND(DATEDIF(H2,J2,"ym")<>0,DATEDIF(H2,J2,"md")=0),"還有"&DATEDIF(H2,J2,"ym")&"個月，滿1年。",
IF(AND(DATEDIF(H2,J2,"ym")<>0,DATEDIF(H2,J2,"md")<>0),"還有"&DATEDIF(H2,J2,"ym")&"個月又"&DATEDIF(H2,J2,"md")&"天，滿1年。"))))))))

會出現FALSE，不知道是什麼原因？請各位老師協助幫忙，萬分感謝！

備註：
=IF(AND(DATEDIF(C2,H2,"y")=0,DATEDIF(C2,H2,"ym")<6), 如果不是就會跳到 IF(AND(DATEDIF(C2,H2,"y")=0,DATEDIF(C2,H2,"ym")>6),
但是他會直接顯示FALSE