Skip to content

Excel Functions

Excel f(x)s = Excel Functions

  • Custom fiscal year calendar (CFlex) Basic Math
  • Excel sessions – 2013 VS 2010 Excel User tips
  • Looplist – Repeating months using formulas Basic Math
  • Expenses calendar, FaCal Basic Math
  • Week number to Month number DATE
  • CamelCase to Camel Case CHAR
  • Multiple Dual-Validations COUNTA
  • Comments versus Notes Excel User tips

Category: NETWORKDAYS

Expenses calendar, FaCal

Posted on December 7, 2018 By ANmar
Expenses calendar, FaCal

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

Workdays – Across months

Posted on November 3, 2015 By ANmar
Workdays – Across months

Get total number of days per month
This was a question from one of my friends, This set of formulas will calculate how many days (Networkdays) in each of the months in the list for a given Start and End dates

If Range of dates are across multiple years, user can copy columns C, D, E and F to fill those years

The months for the list are automatically populated starting from Jan of the year of the start date

The main formula in F7 should be:

Read More “Workdays – Across months” »

DATE, Date and Time, Formulas - combined functions, IF, MONTH, NETWORKDAYS, Standard functions, YEAR

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
  • MID + SEARCH to convert cell to rows MID
  • Convert cell into textbox Excel User tips
  • Multiple lines in cell using functions CHAR
  • Shades of gray Graphics
  • Excel ad from early 90s Non-functions
  • Extract current (Active) workbook name CELL
  • Paste Special Percentage Excel User tips
  • Stale values (Scratched functions) Excel User tips

Copyright © 2026 Excel Functions.

Powered by PressBook News Dark theme