Skip to content
  • Standard
    • Basic Math
    • Date and Time
    • Engineering
    • Information
    • Logical
    • Lookup and References
    • Math and Trig
    • Texts and Strings
    • Formulas – combined functions
    • Array formulas
  • Custom (UDF)
    • What is this UDF?
    • HyperlinkOf UDF
    • WorksheetsNo UDF
    • WorksheetName UDF
    • Num2AR UDF
  • Non-fxs
    • Names
    • Data Validation
    • Conditional Formatting
    • ActiveX controls
    • Graphics
    • Excel User tips
  • About
    • About XLf(x)s
    • King of Excel
    • Admin
  • Search
XLf(x)s
XLf(x)s
Excel functions and formulas
  • Standard
    • Basic Math
    • Date and Time
    • Engineering
    • Information
    • Logical
    • Lookup and References
    • Math and Trig
    • Texts and Strings
    • Formulas – combined functions
    • Array formulas
  • Custom (UDF)
    • What is this UDF?
    • HyperlinkOf UDF
    • WorksheetsNo UDF
    • WorksheetName UDF
    • Num2AR UDF
  • Non-fxs
    • Names
    • Data Validation
    • Conditional Formatting
    • ActiveX controls
    • Graphics
    • Excel User tips
  • About
    • About XLf(x)s
    • King of Excel
    • Admin
  • Search
Category: <span>Standard functions</span>

Category: Standard functions

Home Archive for category "Standard functions"

Standard functions that comes with Excel, plain single functions

Jan8 date format

Jan8 date format
ANmar AND / Date and Time / Formulas - combined functions / IF / Logical / Standard functions / TEXT / Texts and Strings / TODAY  AND / IF / TEXT / TODAY April 24, 2023 April 24, 2023

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, Aug14Else 2020Feb4

Full article"Jan8 date format"

Walking Columns

Walking Columns
ANmar ActiveX controls / Basic Math / COLUMN / Conditional Formatting / Formulas - combined functions / IF / INT / Logical / Lookup and References / Math and Trig / Non-functions / OFFSET / ROW / Standard functions January 14, 2023 January 14, 2023

An easy way to scroll through set of data in a graphic way without graphs. A-pure-formula xlsx workbook. These were done using formulas, conditional formatting, and ActiveX control.

Full article"Walking Columns"

Unix DateTime Number

Unix DateTime Number
ANmar Basic Math / DATE / Date and Time / Standard functions  DATE / Math January 6, 2023 January 6, 2023

Convert Date/time number from regular number to Unix DateTime Number.

Full article"Unix DateTime Number"

Get 3rd Wednesday of month

Get 3rd Wednesday of month
ANmar Basic Math / CHOOSE / DATE / Date and Time / Formulas - combined functions / Lookup and References / MONTH / Standard functions / WEEKDAY / YEAR  3rd / CHOOSE / DATE / MONTH / WEEKDAY / YEAR November 15, 2022 November 15, 2022

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 …

Full article"Get 3rd Wednesday of month"

Repeated Offset

Repeated Offset
ANmar Basic Math / COLUMN / Formulas - combined functions / IFERROR / INT / Logical / Lookup and References / Math and Trig / OFFSET / Standard functions  Column / IF / INT / OFFSET September 19, 2022 September 19, 2022

I needed to have an offset of columns to be repeated every 12 months. This is part of a project, we needed to calculate the coefficient of sales prediction based …

Full article"Repeated Offset"

Sorting with functions only

Sorting with functions only
ANmar CHOOSE / Formulas - combined functions / LARGE / Lookup and References / MATCH / Math and Trig / ROW / SMALL / Standard functions / VLOOKUP September 5, 2022 August 25, 2022

This one is similar to http://xlfxs.com/sort-list-using-functions/ where we use some controls here that make it more user-friendly.

Full article"Sorting with functions only"

6174 Kaprekar’s constant

6174 Kaprekar’s constant
ANmar Basic Math / Formulas - combined functions / Standard functions / TEXT / Texts and Strings / VALUE  6174 / TEXT / VALUE September 2, 2022 August 18, 2022

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

Full article"6174 Kaprekar’s constant"

Posts navigation

1 2 3 … 12
ANmar Amdeen

AND bug cell CHOOSE Column compare CountIF DATE dynamic EU Excel2010 Excel2013 format golast google googletranslate IF INDIRECT INT LEFT LEN link MATCH Math MAX MIN N Non-Functions Number. OFFSET RIGHT Schedule Search shape shapes SUM TEXT TODAY translate TRIM underline US VALUE VLOOKUP WEEKDAY

  • May 2023 (1)
  • April 2023 (2)
  • January 2023 (2)
  • November 2022 (1)
  • October 2022 (1)
  • September 2022 (3)
  • August 2022 (6)
  • July 2022 (9)
  • October 2020 (2)
  • September 2020 (1)
  • July 2020 (1)
  • March 2020 (1)
  • February 2020 (5)
  • August 2019 (1)
  • April 2019 (1)
  • January 2019 (6)
  • December 2018 (7)
  • October 2018 (1)
  • August 2018 (1)
  • April 2018 (2)
  • March 2018 (6)
  • February 2018 (2)
  • December 2017 (3)
  • June 2017 (2)
  • March 2017 (1)
  • February 2017 (2)
  • December 2016 (1)
  • September 2016 (3)
  • November 2015 (1)
  • September 2015 (1)
  • May 2015 (1)
  • April 2015 (2)
  • June 2014 (1)
  • March 2012 (1)
  • February 2012 (14)
  • January 2012 (10)
Log in
Powered by Kahuna & WordPress.
©2018 XLf(x)s=Excel Functions | ANmar.Systems
Back to Top