+ Reply to Thread
Results 1 to 7 of 7

3rd Monday in Month formula help

Hybrid View

  1. 01-10-2022, 10:45 PM #1
    Phuocam
    Phuocam is online now
    Forum Guru
    Join Date
    02-27-2016
    Location
    Vietnam
    MS-Off Ver
    2021
    Posts
    5,988

    Re: 3rd Monday in Month formula help

    Try this

    =WORKDAY.INTL(DATE($A$1,2,0),3,"0111111")
    Reply With QuoteRegister To Reply
  2. 01-10-2022, 10:51 PM #2
    bl1nd
    bl1nd is offline
    Registered User
    Join Date
    11-13-2015
    Location
    Vancouver, Canada
    MS-Off Ver
    2013
    Posts
    29

    Re: 3rd Monday in Month formula help

    I don't understand your formula, but it works lol
    Thank you!
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. [SOLVED] Get First day of the Month and every Monday of the succeeding weeks within that month
    By juan.doe in forum Excel Formulas & Functions
    Replies: 8
    Last Post: 08-14-2018, 05:57 AM
  2. [SOLVED] Formula to Return # of Working Days (Monday through Friday) in the Current Month?
    By EnigmaMatter in forum Excel General
    Replies: 3
    Last Post: 10-11-2014, 09:04 PM
  3. Find every Monday in a month using VBA
    By EmmaO91 in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-10-2014, 07:32 AM
  4. [SOLVED] Need a formula that picks up the date for Monday for each week from a given month and year
    By davisfs2007 in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 04-11-2013, 02:21 PM
  5. Formula to recognise first monday of the month
    By Jonsocks in forum Excel General
    Replies: 8
    Last Post: 09-30-2010, 08:59 AM
  6. formula to calculate numbers of days (i.e. Monday's) in a month
    By Carol in forum Excel - New Users/Basics
    Replies: 3
    Last Post: 07-06-2007, 07:31 AM
  7. need to work out if a monday is the 1st 2nd 3rd or 4th monday of a month
    By Stuart Gillingh in forum Excel General
    Replies: 1
    Last Post: 04-13-2005, 06:35 PM

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1