Skip to content

Excel Functions

Excel f(x)s = Excel Functions

  • Dynamic selection list ActiveX controls
  • Return 12 values in one number AND
  • Search across sheets in function ADDRESS
  • Lesson learned: Do not trust Google Sheets function Google Sheets
  • Show developer tab Excel User tips
  • iframe in Excel (XLiFrame) ADDRESS
  • MID + SEARCH to convert cell to rows MID
  • Looplist – Repeating months using formulas Basic Math

Expenses calendar, FaCal

Posted on December 7, 2018 By ANmar

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 you open, to show current month and shows bills


 

Download FaCal
Excel Online
Basic Math, Conditional Formatting, DATE, Date and Time, MONTH, NETWORKDAYS, Non-functions, Standard functions, TODAY, WEEKDAY, YEAR Tags:bills, Excel calendar, expenses

Post navigation

Previous Post: Custom fiscal year calendar (CFlex)
Next Post: Scorring, saving multiple outputs in 1 number

Related Posts

  • Sum of divide – Array formula Array formula
  • BMI Calculator Basic Math
  • Get 3rd Wednesday of month Basic Math
  • When Excel functions are not enough Excel User tips
  • Insert Blank rows into table using functions CHAR
  • Standard math to calculate Aspect Ratio Basic Math

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
  • Compare2, a tool to compare two sheets using formulas Conditional Formatting
  • BMI Calculator Basic Math
  • Show developer tab Excel User tips
  • Progress bar in pure functions CHAR
  • Excel Functions = XL f(x)s XLfxs
  • Scorring, saving multiple outputs in 1 number Basic Math
  • Shades of gray Graphics
  • Schedule column Basic Math

Copyright © 2026 Excel Functions.

Powered by PressBook News Dark theme