Shopping Cart

No. of Days between two Dates

In Excel, subtracting an Earlier Date from a Later Date will calculate the number of Days in between – which can be very useful.

However, we may need to calculate the number of Working Days between two Dates. If that is the case then NETWORKDAYS() is your goto function.  (Makes more sense if you read this as NET WORKDAYS as opposed to NETWORK DAYS)

It excludes weekends plus has an optional argument that will exclude Holidays and other Non-working Days that you list in a Data Range.

NB! Just like any other Date calculations though, you need to work with genuine dates (auto-aligned to the right), otherwise this will simply error. The default weekend for the NETWORKDAYS()  Function is Saturday and Sunday. If you work Saturdays or have a completely different Weekend, then use NETWORKDAYS.INTL() which has an additional argument that enables you to set your weekend day(s).

To become even more proficient with data ranges, check out one of our online Excel courses, with training offered for both beginners to advanced users.

MS Excel Advanced Course

R 1,550

Course Length: 79 Lessons | 7.5 Hours of Videos

Content Covered

  • Key Essentials
  • Spreadsheet Integrity
  • Cell References
  • Forecasting
  • CSV Import
  • Merging Data
  • Splitting Data
  • Data Validation
  • Worksheet Protection
  • Advanced Formula
  • Text Formula
  • Date Formula
  • Logical Formula
  • Lookup Formula
  • Maths Formula
  • Pivot Tables & Charts
  • Excel Automation (Macros)

MS Excel Intermediate Course

R 1,350

Course Length: 55 Lessons | 5.5 Hours of Videos

Content Covered

  • Key Essentials
  • Series Generation
  • Advanced Copy and Paste
  • Formula
  • Cell Referencing
  • Rounding
  • View Optimization
  • Find and Replace
  • Sort and Filter
  • Graphs
  • Conditional Formatting
  • Ranges vs Tables
  • Pivot Tables
  • VLOOKUP
  • Data Manipulation
  • Keyboard Shortcuts
  • Tips and Tricks

MS Excel Beginner Course

R 1,150

Course Length: 56 Lessons | 4 Hours of Videos

Content Covered

  • Excel Overview
  • Key Essentials
  • Data Input
  • Excel Autofill
  • Formatting Cells
  • Number Formatting
  • Formatting Worksheets
  • Formulas
  • Printing
  • Basic Sort and Filter
  • Visualizing Data
  • Excel’s Golden Rule
  • Pivot Tables Sneak Peek
  • Keyboard Shortcuts
  • Tips and Tricks