Results 1 to 7 of 7

3rd Monday in Month formula help

Threaded View

  1. #1
    Registered User
    Join Date
    11-13-2015
    Location
    Vancouver, Canada
    MS-Off Ver
    2013
    Posts
    29

    3rd Monday in Month formula help

    Hey peeps,

    I am looking for a dynamic formula that returns the 3rd Monday in February based on a year value.
    I am using
    =DATE($A$1,2,25)-WEEKDAY(DATE($A$1,2,2))
    Where A1= the year value.

    This formula works perfectly, except when the 1st of February is on a Monday, then it returns the 4th Monday of the month. What am I doing wrong?
    Last edited by bl1nd; 01-10-2022 at 10:51 PM.

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. 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. 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1