# 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

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"))

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)``

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

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