Skip to content

Excel Functions

Excel f(x)s = Excel Functions

  • Limited Ceiling Basic Math
  • Compare2, a tool to compare two sheets using formulas Conditional Formatting
  • Middle name + 1st name Basic Math
  • Get column name (columnname as A,B,C, etc) as input inside cell ADDRESS
  • Count how many times letter found Formulas - combined functions
  • Sum of divide – Array formula Array formula
  • When Excel functions are not enough Excel User tips
  • Progress bar in pure functions CHAR

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

  • OFFSET+MATCH Formulas - combined functions
  • Why I ran from =INDIRECT() function Formulas - combined functions
  • Workdays – Across months DATE
  • Looplist – Repeating months using formulas Basic Math
  • CamelCase to Camel Case CHAR
  • SimpleANBox 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
  • VLookup Lookup and References
  • Hello world! Uncategorized
  • Text-to-Columns, dynamically using formulas IFERROR
  • Excel @ before function names in formulas Excel User tips
  • Sheet() and Sheets() Lookup and References
  • Fx to cut long column into two columns Formulas - combined functions
  • Cuts string of list of items Formulas - combined functions
  • Week number to Sunday date – Weeknum reverse DATE

Copyright © 2026 Excel Functions.

Powered by PressBook News Dark theme