Results 1 to 7 of 7

Compute the 3rd Friday of the month?

This is a discussion on Compute the 3rd Friday of the month? within the Excel Questions forums, part of the Question Forums category; I put in the month in a cell A1 of lets say 9/1/2003 or September In cell B1 I want ...

  1. #1
    Board Regular
    Join Date
    Mar 2002
    Posts
    137

    Default Compute the 3rd Friday of the month?

    I put in the month in a cell A1 of lets say 9/1/2003 or September

    In cell B1 I want excel to compute the third Friday of that month which in this case is 9/19/2003

    Can that be done?

  2. #2
    MrExcel MVP
    Join Date
    May 2002
    Posts
    13,993

    Default Re: Compute the 3rd Friday of the month?

    =DATE(YEAR(B1),MONTH(B1),14+CHOOSE(WEEKDAY(DATE(YEAR(B1),MONTH(B1),1)),6,5,4,3,2,1,7))

  3. #3
    Board Regular
    Join Date
    Mar 2002
    Posts
    137

    Default Re: Compute the 3rd Friday of the month?

    Thanks that worked out

  4. #4
    MrExcel MVP
    Join Date
    May 2002
    Posts
    13,993

    Default

    you're welcome. i did a sneeky edit for a typo on my original post - if you've got the version that ends ....6)), change it for the one above.

  5. #5
    New Member
    Join Date
    Nov 2010
    Posts
    1

    Default Re: Compute the 3rd Friday of the month?

    how do i find the 1st friday of the month preceding the 3rd wednesday in excel

  6. #6
    Board Regular
    Join Date
    Dec 2002
    Posts
    1,179

    Default Re: Compute the 3rd Friday of the month?

    3rd Friday of the month :

    =A1-DAY(A1)-WEEKDAY(A1-DAY(A1)+2)+22

    Regards

  7. #7
    MrExcel MVP
    Moderator
    barry houdini's Avatar
    Join Date
    Mar 2005
    Location
    England
    Posts
    19,791

    Default Re: Compute the 3rd Friday of the month?

    I think that the 1st Friday preceding the third Wednesday of the month isn't necessarily the same as the 3rd Friday of the month.

    For instance this month the 3rd Wednesday is 17th and the Friday preceding that is the 12th, so to get that result

    =A1-DAY(A1)-WEEKDAY(A1-DAY(A1)+4)+17

    for any date in A1

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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


DMCA.com