Skip to content

Excel Functions

Excel f(x)s = Excel Functions

  • Multiple-Validations (connected to each other) Data Validation
  • Excel Functions = XL f(x)s XLfxs
  • GoLast to jump to last cell in a column CELL
  • Multiple Dual-Validations COUNTA
  • LastSunday, LastSaturday Date and Time
  • Return 12 values in one number AND
  • State Abbr with Index+Match+Validation Data Validation
  • OFFSET+MATCH Formulas - combined functions

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

  • Count how many times letter found Formulas - combined functions
  • Get monthly total from table with dates DATE
  • IF with AND and IF with OR AND
  • FORMULATEXT to show formulas FORMULATEXT
  • Extract Address into table Formulas - combined functions
  • When Excel functions are not enough Excel User tips

Recent Posts

  • Stale values (Scratched functions)
  • Middle name + 1st name
  • LastSunday, LastSaturday
  • Paste Special Percentage
  • Jan8 date format

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 (82)
    • 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 (30)
      • AND (5)
      • IF (24)
      • IFERROR (6)
      • 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 (5)
      • 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
  • Spreadsheet Compare application Excel User tips
  • Cell formats 0.0\% and 0.0%;(0.0%) Format Cells
  • Compare2, a tool to compare two sheets using formulas Conditional Formatting
  • Always get 1st name (or last) Formulas - combined functions
  • Extract current (Active) workbook name CELL
  • VLookup Lookup and References
  • Excel Limits Excel User tips
  • Stale values (Scratched functions) Excel User tips

Copyright © 2025 Excel Functions.

Powered by PressBook News Dark theme