Skip to content

Excel Functions

Excel f(x)s = Excel Functions

  • Excel ad from early 90s Non-functions
  • VLookup Lookup and References
  • Sorting with functions only CHOOSE
  • When Excel tells you to go get some life Excel User tips
  • Progress bar in pure functions CHAR
  • Get 3rd Wednesday of month Basic Math
  • Comments versus Notes Excel User tips
  • Cells with additional spaces 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

  • 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
  • Shapes with dynamic output Excel User tips
  • Get monthly total from table with dates DATE
  • Recover the unrecoverable Excel User tips
  • Get column name (columnname as A,B,C, etc) as input inside cell ADDRESS
  • Limited Ceiling Basic Math
  • State Abbr with Index+Match+Validation Data Validation
  • OFFSET+MATCH Formulas - combined functions
  • Tally chart in functions Formulas - combined functions

Copyright © 2025 Excel Functions.

Powered by PressBook News Dark theme