Return previous working day 1 week in the future
This tutorial shows how to return the previous work day (business day) one week in the future using an Excel formula or VBA
Example: Return previous working day 1 week in the future
|
=WORKDAY(B7+($C$4*7)-1,-1,$F$7:$F$14)
|
This formula uses the Excel WORKDAY function, including the holidays, to calculate the previous working day one week in advance from the selected date.
|
Sub Previous_working_day_in_1_week()
'declare a variable
Dim ws As Worksheet
Dim ws As Worksheet
Set ws = Worksheets("Analysis")
'return the next working day 1 week in the future
ws.Range("C7") = WorksheetFunction.WorkDay(ws.Range("B7") + (ws.Range("C4") * 7) - 1, -1, ws.Range("F7:F14"))
ws.Range("C7") = WorksheetFunction.WorkDay(ws.Range("B7") + (ws.Range("C4") * 7) - 1, -1, ws.Range("F7:F14"))
End Sub
EXPLANATION
This tutorial shows how to return the previous work day (business day) 1 week in the future through the use of an Excel formula or VBA.
Both the Excel formula and VBA methods make use of the WORKDAY function to return the previous working day one week in advance.
FORMULA
=WORKDAY(date+(weeks*7)-1,-1,holidays)
=WORKDAY(date+(weeks*7)-1,-1,holidays)
ARGUMENTS
date: The initial date from which to begin counting the number of working days.
weeks: Number of weeks to add to or subtract from the start date.
holidays: A list of dates that specifies the holidays to take into consideration.
date: The initial date from which to begin counting the number of working days.
weeks: Number of weeks to add to or subtract from the start date.
holidays: A list of dates that specifies the holidays to take into consideration.
RELATED TOPICS
| Related Topic | Description | Related Topic and Description |
|---|---|---|
| Return next working day | How to return the next work day (business day) using Excel and VBA | |
| Return previous working day | How to return the previous work day (business day) using Excel and VBA | |
| Return previous working day 6 months in the future | How to return the previous work day (business day) six months in the future using Excel and VBA | |
| Return previous working day 6 months back | How to return the previous work day (business day) six months back using Excel and VBA |