Skip to content

Excel Functions

Excel f(x)s = Excel Functions

  • Min Max vehicle Formulas - combined functions
  • Hyperlink usage and HyperlinkOf UDF CELL
  • Sorting with functions only CHOOSE
  • Why I ran from =INDIRECT() function Formulas - combined functions
  • VLookup Lookup and References
  • Convert 2-column into wide (column-row) table Formulas - combined functions
  • New function IFERROR, finally IFERROR
  • SimpleANBox Basic Math

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

  • Multiple-Validations (connected to each other) Data Validation
  • CONVERT function CONVERT
  • iframe in Excel (XLiFrame) ADDRESS
  • 6174 Kaprekar’s constant Basic Math
  • CountIf limitation COUNTIF
  • Unix DateTime Number 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
  • Skills Grid Conditional Formatting
  • Jan8 date format AND
  • Cells with additional spaces AND
  • Walking Columns ActiveX controls
  • CountIf limitation COUNTIF
  • Extract current (Active) workbook name CELL
  • Week number to Sunday date – Weeknum reverse DATE
  • The Excel “&” bug Excel User tips

Copyright © 2026 Excel Functions.

Powered by PressBook News Dark theme