推 nisroky: =DAYS(DATE(YEAR(TODAY()),MONTH(TODAY())+4,0),TODAY()) 04/21 12:15
→ soyoso: 當天(今天的話)到四個月後是否指8/21,而月底日為8/31 04/21 12:29
→ soyoso: 如果是的話n大的公式會是7/31來判斷 04/21 12:30
→ soyoso: 如果是8/31的話,=EOMONTH(TODAY(),4)-TODAY() 04/21 12:32
→ soyoso: 如果是7/31的話 ^改為3 04/21 12:34
推 nisroky: 感謝s大指正 04/21 13:14
→ ck3300511: 感謝n大s大 04/21 19:07