本文介绍了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
WEEKDAY

References:
EOMONTH
WEEKDAY

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

08-14 23:30