Skip to content

Excel Functions

Excel f(x)s = Excel Functions

  • Get 3rd Wednesday of month Basic Math
  • State Abbr with Index+Match+Validation Data Validation
  • IFS (and IFNA) to avoid nested IFs Formulas - combined functions
  • Convert 2-column into wide (column-row) table Formulas - combined functions
  • Shapes with dynamic output Excel User tips
  • Count how many times letter found Formulas - combined functions
  • CHOOSE – tree of decisions CHOOSE
  • Recover the unrecoverable Excel User tips

DayName

Posted on January 25, 2019 By ANmar

Simplest way to get name of day as cell output from a date.

Because you can custom format a cell with date to show only that day name

This is not that.

It is to give the day name as cell output.

Using the default computer date settings, if D15 is the cell containing the date…

=TEXT(D15,"dddd")

Date and Time, Standard functions, TEXT, Texts and Strings

Post navigation

Previous Post: Shades of gray
Next Post: When Excel tells you to go get some life

Related Posts

  • Standard math to calculate Aspect Ratio Basic Math
  • 6174 Kaprekar’s constant Basic Math
  • Custom fiscal year calendar (CFlex) Basic Math
  • Searching table in 2 dimensions. Formulas - combined functions
  • GoLast to jump to last cell in a column CELL
  • State Abbr with Index+Match+Validation Data Validation

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
  • Sum of divide – Array formula Array formula
  • Filter. Google Sheets function Google Sheets
  • Extract Address into table Formulas - combined functions
  • Count cells with condition – multiple conditions COUNTIFS
  • Extract current (Active) workbook name CELL
  • Always get 1st name (or last) Formulas - combined functions
  • Lesson learned: Do not trust Google Sheets function Google Sheets
  • LastSunday, LastSaturday Date and Time

Copyright © 2025 Excel Functions.

Powered by PressBook News Dark theme