一、if函數
=IF(DAY(B2)>20,"下旬",IF(DAY(B2)>10,"中旬","上旬"))
二、lookup函數
=LOOKUP(DAY(B2),{0,11,21},{"上旬","中旬","下旬"})
閱讀更多 淡墨留餘香 的文章
2018-06-12 21:24:23 淡墨留餘香
一、if函數
=IF(DAY(B2)>20,"下旬",IF(DAY(B2)>10,"中旬","上旬"))
二、lookup函數
=LOOKUP(DAY(B2),{0,11,21},{"上旬","中旬","下旬"})
閱讀更多 淡墨留餘香 的文章