Skip to content

Excel Functions

Excel f(x)s = Excel Functions

  • IF with AND and IF with OR AND
  • Expenses calendar, FaCal Basic Math
  • FORMULATEXT to show formulas FORMULATEXT
  • WorksheetName and WorksheetsNo UDFs Lookup and References
  • Formula Beautifier Excel User tips
  • CamelCase to Camel Case CHAR
  • Week number to Sunday date – Weeknum reverse DATE
  • MID + SEARCH to convert cell to rows MID

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

  • 6174 Kaprekar’s constant Basic Math
  • MID + SEARCH to convert cell to rows MID
  • Count cells with condition – multiple conditions COUNTIFS
  • Week number to Sunday date – Weeknum reverse DATE
  • FORMULATEXT to show formulas FORMULATEXT
  • Standard math to calculate Aspect Ratio Basic Math

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
  • Sort list dynamically (functions) COLUMN
  • Cuts string of list of items Formulas - combined functions
  • CTRL+Y a mini macro Excel User tips
  • Show developer tab Excel User tips
  • Fx to cut long column into two columns Formulas - combined functions
  • Filter. Google Sheets function Google Sheets
  • Comments versus Notes Excel User tips
  • UDF – Convert Number into text (English and Arabic) User-Defined f(x)s = UDF

Copyright © 2026 Excel Functions.

Powered by PressBook News Dark theme