excel-计算每月剩余的星期一 [英] excel - calculate remaining mondays in each month

查看：86 发布时间：2020/11/1 20:29:41 excel excel-formula

本文介绍了excel-计算每月剩余的星期一的处理方法，对大家解决问题具有一定的参考价值，需要的朋友们下面随着小编来一起学习吧！

我每个星期一都付账单.我想知道这个月要花多少钱.

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?

本月还剩下几个星期一(如果是星期一，则不包括今天)

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

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

下个月有几个星期一

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

参考文献:
EOMONTH

References:
EOMONTH
WEEKDAY

这篇关于excel-计算每月剩余的星期一的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持IT屋！