Return remaining workdays in a month
This tutorial shows how to return the remaining number of working days (business days) in a specific month, based on a specific date, using an Excel formula or VBA
Example: Return remaining workdays in a month
|
=NETWORKDAYS(B5,EOMONTH(B5,0),$F$5:$F$12)
|
This formula uses the Excel NETWORKDAYS and EOMONTH functions to return the remaining number of working days (business days) in a specific month based on a specific date, including the actual day of the specified date if it is a workday. It also takes into consideration the holidays that are in that particular month.
|
Sub Return_remaining_workdays_in_month()
'declare variables
Dim ws As Worksheet
Dim ws As Worksheet
Set ws = Worksheets("Analysis")
'return the remaining number of working days in a month
ws.Range("C5") = WorksheetFunction.NetworkDays(ws.Range("B5"), WorksheetFunction.EoMonth(ws.Range("B5"), 0), ws.Range("F5:F12"))
End Sub
EXPLANATION
This tutorial shows how to return the remaining number of working days in a specific month, based on a specific date, through the use of an Excel formula or VBA.
The Excel and VBA methods both use the NETWORKDAYS and EOMONTH functions to return the remaining number of workdays (business days) in a specific month, based on a specific date, including the actual day of the date if it is a workday.
FORMULA
=NETWORKDAYS(date,EOMONTH(date,0),holidays)
=NETWORKDAYS(date,EOMONTH(date,0),holidays)
ARGUMENTS
date: The date from which you want to extract the number of remaining working days in that month.
holidays: A list of dates that captures the holidays to take into consideration.
date: The date from which you want to extract the number of remaining working days in that month.
holidays: A list of dates that captures the holidays to take into consideration.
RELATED TOPICS
| Related Topic | Description | Related Topic and Description |
|---|---|---|
| Return workdays in a month | How to return the number of working days in a month using Excel and VBA | |
| Return next working day | How to return the next work day (business day) using Excel and VBA | |
| Return next working day 6 months in the future | How to return the next work day (business day) six months in the future using Excel and VBA |