excel - calculate remaining mondays in each month

2019-09-03 16:04发布

I pay a bill every monday. I want to know how much more this is going to cost me this month.

How do I calculate how many mondays are in an upcoming month? For the current month, how do I calculate remaining mondays after today?

标签: excel
1条回答
乱世女痞
2楼-- · 2019-09-03 16:48

How many Mondays remaining this month (excluding today if it's a Monday)

=INT((EOMONTH(TODAY(),0)-TODAY()+WEEKDAY(TODAY(),3))/7)

How many Mondays next month

=INT((EOMONTH(TODAY(),1)-EOMONTH(TODAY(),0)+WEEKDAY(EOMONTH(TODAY(),0),3))/7)

References:
EOMONTH
WEEKDAY

查看更多
登录 后发表回答