Skip to content

Excel Functions

Excel f(x)s = Excel Functions

  • Convert 2-column into wide (column-row) table Formulas - combined functions
  • Lesson learned: Do not trust Google Sheets function Google Sheets
  • iframe in Excel (XLiFrame) ADDRESS
  • Sort list dynamically (functions) COLUMN
  • Jan8 date format AND
  • Worksheet name, dynamically using formula CELL
  • Count cells with condition – multiple conditions COUNTIFS
  • Sorting with functions only CHOOSE

Get 3rd Wednesday of month

Posted on November 15, 2022 By ANmar

This was an interesting request.

Needing to get the date of 3rd Wednesday for a given month, automatically, using pure Excel functions.

So, sharing here on what is the formula and how to get there.

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

Download
Excel Online

Basic Math, CHOOSE, DATE, Date and Time, Formulas - combined functions, Lookup and References, MONTH, Standard functions, WEEKDAY, YEAR Tags:3rd, CHOOSE, DATE, MONTH, WEEKDAY, YEAR

Post navigation

Previous Post: Spreadsheet Compare application
Next Post: Unix DateTime Number

Related Posts

  • Search across sheets in function ADDRESS
  • Rotate table using 1 formula ADDRESS
  • SimpleANBox Basic Math
  • Links between two workbooks – dynamically using functions INDIRECT
  • Excel @ before function names in formulas Excel User tips
  • CHOOSE – tree of decisions CHOOSE

Recent Posts

  • Calculate above and below me
  • Stale values (Scratched functions)
  • Middle name + 1st name
  • LastSunday, LastSaturday
  • Paste Special Percentage

Archives

Categories

  • Array formula (1)
  • Formulas – combined functions (58)
  • Google Sheets (2)
  • Non-functions (36)
    • ActiveX controls (2)
    • Conditional Formatting (7)
    • Data Validation (7)
    • Excel User tips (19)
    • Format Cells (6)
    • Graphics (4)
    • Names (3)
  • Standard functions (83)
    • Basic Math (18)
    • Date and Time (16)
      • DATE (9)
      • Hour (1)
      • MONTH (7)
      • NETWORKDAYS (2)
      • TODAY (7)
      • WEEKDAY (8)
      • WEEKNUM (1)
      • YEAR (8)
    • Engineering (1)
      • CONVERT (1)
    • Information (6)
      • CELL (4)
      • ISERROR (1)
      • N (1)
    • Logical (31)
      • AND (5)
      • IF (25)
      • IFERROR (7)
      • IFNA (1)
      • IFS (1)
      • ISERROR (1)
      • OR (2)
    • Lookup and References (36)
      • ADDRESS (4)
      • CHOOSE (3)
      • COLUMN (7)
      • FORMULATEXT (1)
      • HLOOKUP (1)
      • HYPERLINK (2)
      • INDEX (5)
      • INDIRECT (6)
      • MATCH (12)
      • OFFSET (15)
      • ROW (11)
      • VLOOKUP (5)
    • Math and Trig (24)
      • ABS (1)
      • CEILING (1)
      • COUNT (1)
      • COUNTA (4)
      • INT (9)
      • LARGE (2)
      • MAX (1)
      • Min (2)
      • SMALL (3)
      • SUM (3)
      • SUMIF (1)
      • SUMIFS (2)
      • SUMPRODUCT (1)
    • Statistical (6)
      • Average (1)
      • COUNTIF (4)
      • COUNTIFS (1)
    • Texts and Strings (24)
      • CHAR (5)
      • CONCATINATE (1)
      • FIND (1)
      • LEFT (8)
      • Len (4)
      • MID (9)
      • REPT (3)
      • RIGHT (2)
      • SEARCH (9)
      • STRING (1)
      • SUBSTITUTE (2)
      • TEXT (4)
      • TRIM (2)
      • VALUE (2)
  • Uncategorized (2)
  • User-Defined f(x)s = UDF (3)
    • HyperlinkOf (1)
  • Worksheet (16)
  • XLfxs (2)

Meta

  • Log in
  • Entries feed
  • Comments feed
  • WordPress.org
  • DayName Date and Time
  • FORMULATEXT to show formulas FORMULATEXT
  • Comments versus Notes Excel User tips
  • Sort list dynamically (functions) COLUMN
  • IF with AND and IF with OR AND
  • Fixed length ID Formulas - combined functions
  • Edit directly in cell Excel User tips
  • Zipcode-State search Formulas - combined functions

Copyright © 2026 Excel Functions.

Powered by PressBook News Dark theme