Skip to content

Excel Functions

Excel f(x)s = Excel Functions

  • FORMULATEXT to show formulas FORMULATEXT
  • Looplist – Repeating months using formulas Basic Math
  • Sort list dynamically (functions) COLUMN
  • Edit directly in cell Excel User tips
  • DayName Date and Time
  • Cuts string of list of items Formulas - combined functions
  • Cells with additional spaces AND
  • Highlight dates dynamically AND

Tag: TEXT

Jan8 date format

Posted on April 24, 2023 By ANmar
Jan8 date format

Format a date in shortest format possible indicating how many days have passed (Past date)

If date1-date2 < 8 Sat, Fri, …
If date1-date2 < 350 Dec24, Jan4, Aug14
Else 2020Feb4

Read More “Jan8 date format” »

AND, Date and Time, Formulas - combined functions, IF, Logical, Standard functions, TEXT, Texts and Strings, TODAY

6174 Kaprekar’s constant

Posted on September 2, 2022 By ANmar
6174 Kaprekar’s constant

This is the spreadsheet to prove this constant. When all roads lead to Kaprekar

Just enter any 4 digits number in D3 and watch roads walk you 6174

Read More “6174 Kaprekar’s constant” »

Basic Math, Formulas - combined functions, Standard functions, TEXT, Texts and Strings, VALUE

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
  • Zipcode-State search Formulas - combined functions
  • Dynamic selection list ActiveX controls
  • Fixed length ID Formulas - combined functions
  • Sort list dynamically (functions) COLUMN
  • Progress bar in pure functions CHAR
  • Excel ad from early 90s Non-functions
  • When Excel functions are not enough Excel User tips
  • Count Unique COUNTIF

Copyright © 2026 Excel Functions.

Powered by PressBook News Dark theme