当前位置：网站首页>Excel calculates the remaining days of the month

Excel calculates the remaining days of the month

2022-07-19 05:19:00 【dafeng2773】

It's today 2021 year 4 month 12 Number , Want to know how many days are left this month , stay Excel How to realize it in ？

stay Excel in ,Eomonth function , You can calculate that N The date of the last day of the month after months .

Parameter meaning ：

Start_date: Indicates a specific date , Such as 2021/4/12

Month： yes Start_date Before / Months after

Eomonth(today(),0), Return to the last day of the month

Eomonth(today(),1), Return to the last day of the next month

therefore , The formula for the remaining days of this month can be written as ：

=DAY(EOMONTH(TODAY(),0))-DAY(TODAY())

版权声明
本文为[dafeng2773]所创，转载请带上原文链接，感谢
https://yzsam.com/2022/200/202207170503287760.html