Return previous working day 1 week back

This tutorial shows how to return the previous work day (business day) one week back using an Excel formula or VBA

Example: Return previous working day 1 week back

Return previous working day 1 week back

METHOD 1. Return previousworking day 1 week back using Excel formula

EXCEL

=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 back from the selected date.

METHOD 1. Return previous working day 1 week back using VBA

VBA

Sub Previous_working_day_1_back()
'declare a variable
Dim ws As Worksheet
Set ws = Worksheets("Analysis")
'return the previous 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"))

End Sub

Explanation about how to return previous working day 1 week back

EXPLANATION

EXPLANATION

This tutorial shows how to return the previous work day (business day) 1 week back 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 back.
FORMULA
=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.

RELATED TOPICS

Related Topic Description Related Topic and Description
How to return the next work day (business day) using Excel and VBA
How to return the previous work day (business day) using Excel and VBA
How to return the previous work day (business day) one week in the future using Excel and VBA
How to return the previous work day (business day) six months back using Excel and VBA
How to return the next work day (business day) one week in the future using Excel and VBA