Re: [算表] 月份分上下半月
※ 引述《giveme520 ()》之銘言:
: 軟體:
: office excel
: 版本:
: 365
: 是否有辦法將月份歸類為上下半月的方式呢?謝謝
: 2016/09/01 =>beofre 9/15
: 2016/09/15 =>before 9/15
: 2016/09/23 =>after 9/15
: 2016/10/16 =>after 10/15
: ...etc
欄A 欄B
1 日期 格式
2 9/1 IF(DAY(A2)<=15,"befort"&MONTH(A2)&"/15","after "&MONTH(A2)&"/15")
利用字串串接的原理就可以做得到
不過 單字您好像拼錯了
--
※ 發信站: 批踢踢實業坊(ptt.cc), 來自: 210.61.117.99
※ 文章網址: https://www.ptt.cc/bbs/Office/M.1475121980.A.CFC.html
→
09/29 12:16, , 1F
09/29 12:16, 1F
→
09/29 12:18, , 2F
09/29 12:18, 2F
→
09/29 12:21, , 3F
09/29 12:21, 3F
→
09/29 12:21, , 4F
09/29 12:21, 4F
→
09/29 12:23, , 5F
09/29 12:23, 5F
→
09/29 21:47, , 6F
09/29 21:47, 6F
→
09/29 21:48, , 7F
09/29 21:48, 7F
→
09/29 21:48, , 8F
09/29 21:48, 8F
→
09/29 21:50, , 9F
09/29 21:50, 9F
→
09/29 21:50, , 10F
09/29 21:50, 10F
→
09/29 21:51, , 11F
09/29 21:51, 11F
→
09/29 21:52, , 12F
09/29 21:52, 12F
→
09/29 23:12, , 13F
09/29 23:12, 13F
→
09/29 23:41, , 14F
09/29 23:41, 14F
推
10/03 19:53, , 15F
10/03 19:53, 15F
→
10/03 19:53, , 16F
10/03 19:53, 16F
討論串 (同標題文章)