+ Reply to Thread
Results 1 to 4 of 4

How to know how many Mondays in current month

  1. #1
    Forum Contributor
    Join Date
    11-10-2019
    Location
    India
    MS-Off Ver
    2010
    Posts
    143

    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. #2
    Forum Contributor
    Join Date
    11-10-2019
    Location
    India
    MS-Off Ver
    2010
    Posts
    143

    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. #3
    Valued Forum Contributor wk9128's Avatar
    Join Date
    08-15-2020
    Location
    Malaysia
    MS-Off Ver
    EXCEL 2007/365
    Posts
    1,122

    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)
    Last edited by wk9128; 06-25-2021 at 11:13 AM.

  4. #4
    Forum Expert etaf's Avatar
    Join Date
    10-22-2004
    Location
    Wittering, West Sussex, UK
    MS-Off Ver
    365 for Mac OSX & Windows
    Posts
    6,701

    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
    Wayne

    if my assistance has helped, and only if you wish to , there is an "* Add Reputation" on the left hand side - you can add to my reputation here

    If you have a solution to your thread - Please mark your thread solved do the following: >
    Select Thread Tools-> Mark thread as Solved. To undo, select Thread Tools-> Mark thread as Unsolved.

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Set PivotTable Filter to Current Day, Current Week, Current Month, or Current Year
    By EnigmaMatter in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 10-30-2014, 08:31 AM
  2. number of mondays in a month formula
    By TechRetard in forum Excel General
    Replies: 6
    Last Post: 12-01-2011, 04:09 PM
  3. Number of Mondays left in current month
    By JuJuBe in forum Excel General
    Replies: 3
    Last Post: 09-20-2010, 06:51 PM
  4. Count Mondays worked in Month
    By harnagel in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 12-08-2005, 11:12 AM
  5. Count Mondays worked in Month
    By harnagel in forum Excel Formulas & Functions
    Replies: 6
    Last Post: 12-06-2005, 05:10 AM
  6. Date function: 1st, 3rd and 5th Mondays of a month
    By vvaidya@pol.net in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 11-02-2005, 06:20 PM
  7. Replies: 5
    Last Post: 01-04-2005, 05:06 PM

Tags for this Thread

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1