# How to know how many Mondays in current month

1. ## How to know how many Mondays in current month

Hi,

Based on computer date, what would be the formulae to know how many Mondays are there in current month please  Register To Reply

2. ## Re: How to know how many Mondays in current month

Sorry I go it

=SUMPRODUCT(N(TEXT(ROW(INDIRECT(DATE(YEAR(TODAY()),MONTH(TODAY()),1)&":"&EOMONTH(DATE(YEAR(TODAY()),MONTH(TODAY()),1),0))),"ddd")="Mon"))  Register To Reply

3. ## Re: How to know how many Mondays in current month

Try

Monday = 1
Tuesday = 2
Wednesday = 3
Thursday = 4
Friday = 5
Saturday = 6
Sunday = 7

HTML Code:
``=SUMPRODUCT((WEEKDAY(ROW(INDIRECT(EOMONTH(NOW(),-1)+1&":"&EOMONTH(NOW(),0))),2)=1)*1)``  Register To Reply

4. ## Re: How to know how many Mondays in current month

this should work
=NETWORKDAYS.INTL(DATE(YEAR(TODAY()),MONTH(TODAY()),1),EOMONTH(DATE(YEAR(TODAY()),MONTH(TODAY()),1),0),"0111111")
the 0111111
decides the day of week starting MON

https://exceljet.net/excel-functions....intl-function  Register To Reply

There are currently 1 users browsing this thread. (0 members and 1 guests) 