NETWORKDAYS is another useful function through which you can use Excel to find days between two dates. It calculates the number of whole working days between two given dates.

Learn how to create a self-updating work schedule in Excel to save time, reduce errors, and streamline your team’s workflow.

How many days? Excel doesn’t offer a function that returns the total number of days in a specified month, and before EOMONTH () came around, an expression to do so was complex.