Skip to content

Excel Functions

Excel f(x)s = Excel Functions

  • Fixed length ID Formulas - combined functions
  • VLookup Lookup and References
  • Limited Ceiling Basic Math
  • GoLast to jump to last cell in a column CELL
  • Paste Special Percentage Excel User tips
  • Expenses calendar, FaCal Basic Math
  • Count Unique COUNTIF
  • Return 12 values in one number AND

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

  • 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
  • Excel sessions – 2013 VS 2010 Excel User tips
  • Sort list dynamically (functions) COLUMN
  • Cell formats 0.0\% and 0.0%;(0.0%) Format Cells
  • Excel ad from early 90s Non-functions
  • Week number to Month number DATE
  • Highlight dates dynamically AND
  • BMI Calculator Basic Math
  • Always get 1st name (or last) Formulas - combined functions

Copyright © 2026 Excel Functions.

Powered by PressBook News Dark theme