Skip to content

Excel Functions

Excel f(x)s = Excel Functions

  • Fx to cut long column into two columns Formulas - combined functions
  • Custom fiscal year calendar (CFlex) Basic Math
  • GoLast to jump to last cell in a column CELL
  • VALUE() of LEFT() Formulas - combined functions
  • Count how many times letter found Formulas - combined functions
  • Sorting with functions only CHOOSE
  • IF with AND and IF with OR AND
  • Pixel Excel Drawing Format Cells

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 lines in cell using functions CHAR
  • Expenses calendar, FaCal Basic Math
  • Skills Grid Conditional Formatting
  • CONVERT function CONVERT
  • Week number to Sunday date – Weeknum reverse DATE
  • 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
  • Validation based on another Validation COUNTA
  • Show developer tab Excel User tips
  • UDF – Convert Number into text (English and Arabic) User-Defined f(x)s = UDF
  • Repeated Offset Basic Math
  • Fx to cut long column into two columns Formulas - combined functions
  • Cuts string of list of items Formulas - combined functions
  • VALUE() of LEFT() Formulas - combined functions
  • SimpleANBox Basic Math

Copyright © 2026 Excel Functions.

Powered by PressBook News Dark theme