excel 函数能不能算旬期?

2025-04-07 23:10:26
推荐回答(1个)
回答1:

假定日期在A1,公式如下:
=IF(DAY(A1)<=10,"上旬",IF(DAY(A1)<=20,"中旬","下旬"))