Excel Tutorial - Number of Work Days Between Two Dates - Custom VBA Function
In this tutorial, I will show you how to calculate the number of working days (M-F) between two dates. I'll use the NETWORKDAYS function to exclude Saturdays, Sundays, and holidays. Then, I'll show you how to create a custom VBA function to exclude any days you want. Let's say you work Mon thru Sat, but not Sun. This function will cover that.
Length:
07:34