Excel Formula or VBA Last month last Business day

[ItalianPlatinum]

Hello - Looking for a way to pull last month's last business day based off of today's date, formula or VBA will work. I tried using EOMONTH but it just returns me current month last day. See below:

Book2
	A	B
1	Today	9/2/2020
2	Last BD of Last Month	8/31/2020
Sheet4

Cell Formulas
Range	Formula
B1	B1	=TODAY()

 

[VBE313]

I just tried

=EOMONTH(TODAY(),-1)

and it gave me 8/31/2020. Isn't that what you want?

 

[ItalianPlatinum]

I just tried

=EOMONTH(TODAY(),-1)

and it gave me 8/31/2020. Isn't that what you want?

But does that just give last day and not last business day? that is the other dilemma i was having

 

[Fluff]

How about
=WORKDAY(EOMONTH(TODAY(),-1)+1,-1)

 

[ItalianPlatinum]

How about
=WORKDAY(EOMONTH(TODAY(),-1)+1,-1)

that is returning last day. i tried 6/2 as a test and it's yielding 5/31 should be 5/29. but i think i can work around it i can use last day still and just apply filtering to get what i need

 

[Fluff]

Not for me it doesn't, did you change the formula?

+Fluff New.xlsm
	B
1	02/06/2020
2	29/05/2020
Data

Cell Formulas
Range	Formula
B2	B2	=WORKDAY(EOMONTH(B1,-1)+1,-1)

 

[ItalianPlatinum]

Not for me it doesn't, did you change the formula?

+Fluff New.xlsm
	B
1	02/06/2020
2	29/05/2020
Data

Cell Formulas
Range	Formula
B2	B2	=WORKDAY(EOMONTH(B1,-1)+1,-1)

ohhh i missed the workday part. OOPS. ty

 

[Fluff]

Glad we could help & thanks for the feedback.