Skip to content

Excel Functions

Excel f(x)s = Excel Functions

  • Hello world! Uncategorized
  • Scorring, saving multiple outputs in 1 number Basic Math
  • Comments versus Notes Excel User tips
  • Worksheet name, dynamically using formula CELL
  • LastSunday, LastSaturday Date and Time
  • Workdays – Across months DATE
  • Limited Ceiling Basic Math
  • FORMULATEXT to show formulas FORMULATEXT

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

  • LastSunday, LastSaturday Date and Time
  • Multiple-Validations (connected to each other) Data Validation
  • Validation based on another Validation COUNTA
  • Hyperlink usage and HyperlinkOf UDF CELL
  • iframe in Excel (XLiFrame) ADDRESS
  • Calculate hours between two cells ABS

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
  • When Excel tells you to go get some life Excel User tips
  • Repeated Offset Basic Math
  • GoLast to jump to last cell in a column CELL
  • Return 12 values in one number AND
  • Links between two workbooks – dynamically using functions INDIRECT
  • Excel @ before function names in formulas Excel User tips
  • Week number to Month number DATE
  • Hyperlink usage and HyperlinkOf UDF CELL

Copyright © 2026 Excel Functions.

Powered by PressBook News Dark theme