Excel formula for business day 3 and business day 2

[Sarah7828]

Hi

Is there a excel formula to get specific dates with the parameters as follows

From 3rd business day in the prior month to the 2nd business day in the current month

Thank you

 

[arthurbr]

Hi Please define the business week you are talking about . Mo to Fr, Mo to Sat ,...?

 

[Sarah7828]

Hi

Not Saturday or Sunday or public holiday

 

[Sarah7828]

Workday.intl(my start day, 5, 1, list of public holidays)

 

[Sarah7828]

Can the formula work

 

[Dave Patton]

WorkDays.xlsm
	C	D
1
2	Thu 03-Oct-2024	Mon 04-Nov-2024
3
2c

Cell Formulas
Range	Formula
C2	C2	=WORKDAY.INTL(EOMONTH(TODAY(),-2),3,1,Holidays)
D2	D2	=WORKDAY.INTL(EOMONTH(TODAY(),-1),2,1,Holidays)

 

[Sarah7828]

Than you Dave

 

[Dave Patton]

Thanks for the feedback.

 

[Dave Patton]

If you want to create both dates with one formula, enter the formula in a cell such as C3

WorkDays.xlsm
	C	D
3	Thu 03-Oct-2024	Mon 04-Nov-2024
2c

Cell Formulas
Range	Formula
C3:D3	C3	=WORKDAY.INTL(EOMONTH(TODAY(),{-2,-1}),{3,2},1,Holidays)
Dynamic array formulas.

 

[Sarah7828]

Thank you David prefer the 1st option. Appreciate all your help