Return elapsed workdays in a month

This tutorial shows how to return the number of working days (business days) that have already passed in a specific month, based on a specific date, using an Excel formula or VBA

Example: Return elapsed workdays in a month

Return elapsed workdays in a month

METHOD 1. Return elapsed workdays in a month using Excel formula

EXCEL

=-NETWORKDAYS(B5,EOMONTH(B5,-1)+1,$F$5:$F$12)
This formula uses the Excel NETWORKDAYS and EOMONTH functions to return the number of working days (business days) that have elapsed 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.

METHOD 1. Return elapsed workdays in a month using VBA

VBA

Sub Return_elapsed_workdays_in_month()
'declare variables
Dim ws As Worksheet
Set ws = Worksheets("Analysis")
'return the elapsed number of working days in a month

ws.Range("C5") = -WorksheetFunction.NetworkDays(ws.Range("B5"), WorksheetFunction.EoMonth(ws.Range("B5"), -1) + 1, ws.Range("F5:F12"))

End Sub

Explanation about how to return elapsed workdays in a month

EXPLANATION

EXPLANATION

This tutorial shows how to return the number of working days that have gone past 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 elapsed 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,-1)+1,holidays)
ARGUMENTS
date: The date from which you want to extract the number of elapsed 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
How to return the remaining number of working days (business days) in a specific month, based on a specific date, using Excel and VBA
How to return the number of working days in a month using Excel and VBA
How to return the next work day (business day) using Excel and VBA