假设日期写在A1单元格
则另一格写入公式
=IF(A1="","",TEXT(DATE(,MONTH(A1)+(DAY(A1)>25),1),"m月份"))
或
=IF(A1="","",MONTH(DATE(,MONTH(A1)+(DAY(A1)>25),1))&"月份")
如果到12月时不要跨年显示成1月份,则公式为
=IF(A1="","",TEXT(DATE(,MIN(12,MONTH(A1)+(DAY(A1)>25)),1),"m月份"))
或
=IF(A1="","",MONTH(DATE(,MIN(12,MONTH(A1)+(DAY(A1)>25)),1))&"月份")
