本文介绍了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)
References:EOMONTH
WEEKDAY
这篇关于excel-计算每月剩余的星期一的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持!