1.Excel函数，计算日期，并且只显示到当月的最后一天
"A11"是当前单元格的上一个单元格，"$I$2"是写入当前月份的单元格（yyyy/M/d格式）
=IFERROR(IF(MONTH(A11+1)=MONTH($I$2),A11+1,""),"")
Register as a new user and use Qiita more conveniently
- You get articles that match your needs
- You can efficiently read back useful information
- You can use dark theme