Excel VBA – NetworkDays Formula

In Excel, there are plenty of ways to calculate the differences between days. However, the NetworkDays Formula includes weekends and may include the holidays, which would be different for each country/province. Thus, it is useful!

blog-excel-logo

Here is how to use the NetworkDays formula in a new spreadsheet in Excel with VBA:

In general it would take only the newly populated values in column A and thus it would give you a nice result. The Microsoft documentation is here.

About

VBA Developer

Tagged with: , ,