Excel Formula For Start Date and End Date

[geh17]

Hello,

Need some help to create a formula for start date and end date. The requirement is the start date and end date should always be previous business day but if the current date falls on Monday, the date that will be captured for start date should be Friday's date and end date would be Sunday's date. Please see example below for illustration:

Current date is 9/5 2023:

START DATE: 9/4/2023
END DATE: 9/4/2023

Current date is 9/4 2023:

START DATE: 9/1/2023
END DATE: 9/3/2023


Thank you.

 

[Fluff]

Cross-posting (posting the same question in more than one forum) is not against our rules, but the method of doing so is covered by #13 of the Forum Rules.

Be sure to follow & read the link at the end of the rule too!

Cross posted at: Excel Formula For Start Date and End Date
There is no need to repeat the link(s) provided above but if you have posted the question at other places, please provide links to those as well.

If you do cross-post in the future and also provide links, then there shouldn’t be a problem.

 

[Fluff]

How about

Fluff.xlsm
	A	B	C
1
2	05/09/2023	04/09/2023	04/09/2023
3	04/09/2023	01/09/2023	03/09/2023
Sheet4

Cell Formulas
Range	Formula
B2:B3	B2	=WORKDAY(A2,-1)
C2:C3	C2	=WORKDAY.INTL(A2,-1,"0000000")