How to count the number of days / workdays / weekends between two dates in Excel?
Posted by jpluimers on 2021/03/09
For my link archive as the Excel functions WORKDAY [WayBack] and NETWORKDAYS [WayBack] helped me finding the working days in a month a while ago: [WayBack] How to count the number of days / workdays / weekends between two dates in Excel?.
Note:
- there is also
DATEDIF[WayBack], but I just subtracted two days and added 1 to the result for that - the more elaborate
NETWORKDAYS.INTL[WayBack] has an extraweekdaysparameter as compared toNETWORKDAYS - similarly there is
WORKDAY.INTL[WayBack] with the sameweekdaysparameter - more methods at [WayBack] Date and time functions (reference) – Office Support
–jeroen
Leave a Comment