Skip to content

Excel Functions

Excel f(x)s = Excel Functions

  • Convert cell into textbox Excel User tips
  • MATCH fumction, just a simple search Lookup and References
  • Shades of gray Graphics
  • Text-to-Columns, dynamically using formulas IFERROR
  • IF with AND and IF with OR AND
  • Filter. Google Sheets function Google Sheets
  • Calculate hours between two cells ABS
  • Compare2, a tool to compare two sheets using formulas Conditional Formatting

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

  • The Excel “&” bug Excel User tips
  • Sheet() and Sheets() Lookup and References
  • Cuts string of list of items Formulas - combined functions
  • BMI Calculator Basic Math
  • Middle name + 1st name Basic Math
  • Repeated Offset Basic Math

Recent Posts

  • Stale values (Scratched functions)
  • Middle name + 1st name
  • LastSunday, LastSaturday
  • Paste Special Percentage
  • Jan8 date format

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 (82)
    • 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 (30)
      • AND (5)
      • IF (24)
      • IFERROR (6)
      • 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 (5)
      • 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
  • Extract Address into table Formulas - combined functions
  • Min Max vehicle Formulas - combined functions
  • When Excel functions are not enough Excel User tips
  • IFS (and IFNA) to avoid nested IFs Formulas - combined functions
  • Show developer tab Excel User tips
  • Scorring, saving multiple outputs in 1 number Basic Math
  • Excel Functions = XL f(x)s XLfxs
  • Cell formats 0.0\% and 0.0%;(0.0%) Format Cells

Copyright © 2026 Excel Functions.

Powered by PressBook News Dark theme