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>TODAY</span>

Category: TODAY

Home Standard functions Date and Time Archive for category "TODAY"

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"

SimpleANBox

SimpleANBox
ANmar Basic Math / DATE / Date and Time / Formulas - combined functions / IF / IFERROR / Logical / Math and Trig / SUM / TODAY / WEEKDAY / Worksheet  DATE / IF / IFERROR / SUM / TODAY / WEEKDAY January 21, 2019 August 9, 2019

This is a financial box, a saving account, a credit, a loan, or any other financial amount that has input and output. During my time with technology (since 1997) I …

Full article"SimpleANBox"

Expenses calendar, FaCal

Expenses calendar, FaCal
ANmar Basic Math / Conditional Formatting / DATE / Date and Time / MONTH / NETWORKDAYS / Non-functions / Standard functions / TODAY / WEEKDAY / YEAR  bills / Excel calendar / expenses December 7, 2018 December 6, 2018

Expenses calendar, to show when in a month you need to pay what bill An easy formula-only smart sheet to allow you get hold on your bills Refreshes every time …

Full article"Expenses calendar, FaCal"

Custom fiscal year calendar (CFlex)

Custom fiscal year calendar (CFlex)
ANmar Basic Math / Conditional Formatting / Data Validation / DATE / Date and Time / MONTH / Non-functions / Standard functions / TODAY / WEEKDAY / YEAR  calendar / fiscal December 5, 2018 December 5, 2018

Fully customized Yearly Calendar to show certain dates with certain format using conditional formatting, like mark 8th business day each month with certain color, 1st workday after 15th of each …

Full article"Custom fiscal year calendar (CFlex)"

Highlight dates dynamically

Highlight dates dynamically
ANmar AND / Conditional Formatting / Non-functions / Standard functions / TODAY March 14, 2018 March 15, 2018

Conditional formatting is another powerful feature in Excel, especially when you combine it with functions A simple function as in below if you set it up inside Conditional formatting, can …

Full article"Highlight dates dynamically"

Week number to Month number

Week number to Month number
ANmar DATE / Date and Time / Formulas - combined functions / IF / Logical / MONTH / TODAY / WEEKDAY / YEAR May 11, 2015 February 22, 2017

Now we need to convert week number to month number This is exactly the same as week number to date (reverse weeknum) So, when the week number is in A5, …

Full article"Week number to Month number"

Week number to Sunday date – Weeknum reverse

Week number to Sunday date – Weeknum reverse
ANmar DATE / Date and Time / Formulas - combined functions / Standard functions / TODAY / WEEKDAY / WEEKNUM / YEAR June 17, 2014 February 21, 2017

This was a request from one of my work managers She wanted to convert a week number she got in a column into thier dates Excel already have the WEEKNUM …

Full article"Week number to Sunday date – Weeknum reverse"
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