Skip to content

Excel Functions

Excel f(x)s = Excel Functions

  • FORMULATEXT to show formulas FORMULATEXT
  • Calculate above and below me Average
  • Return 12 values in one number AND
  • Spreadsheet Compare application Excel User tips
  • Sorting with functions only CHOOSE
  • Insert Blank rows into table using functions CHAR
  • VALUE() of LEFT() Formulas - combined functions
  • Count how many times letter found Formulas - combined functions

Custom fiscal year calendar (CFlex)

Posted on December 5, 2018 By ANmar

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 month, etc.
See the sheet “Data” for details and table of specific dates and rules. Contact me for more detail

Back in 2011, we needed to publish this calendar, so, a dynamic calendar using formulas seems the best option.

Here it is, for free.

 


Download CFlex
Excel Online
Basic Math, Conditional Formatting, Data Validation, DATE, Date and Time, MONTH, Non-functions, Standard functions, TODAY, WEEKDAY, YEAR Tags:calendar, fiscal

Post navigation

Previous Post: Compare2, a tool to compare two sheets using formulas
Next Post: Expenses calendar, FaCal

Related Posts

  • Standard math to calculate Aspect Ratio Basic Math
  • Dynamic selection list ActiveX controls
  • Min Max vehicle Formulas - combined functions
  • Insert Blank rows into table using functions CHAR
  • Validation based on another Validation COUNTA
  • Multiple lines in cell using functions CHAR

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
  • Worksheet name, dynamically using formula CELL
  • Multiple lines in cell using functions CHAR
  • Sorting with functions only CHOOSE
  • Cells with additional spaces AND
  • Looplist – Repeating months using formulas Basic Math
  • Excel @ before function names in formulas Excel User tips
  • Progress bar in pure functions CHAR
  • Stale values (Scratched functions) Excel User tips

Copyright © 2026 Excel Functions.

Powered by PressBook News Dark theme