Last banking day

[scottylad2]

Good day. I’m looking for a formula to identify the last banking day of each month. The weeks starts on a Monday and ends on a Sunday. The last banking day will be a weekday. I don’t need to account for holidays at this point

Thanks in advance

 

[Peter_SSs]

I suggest that you update your Account details (or click your user name at the top right of the forum) so helpers always know what Excel version(s) & platform(s) you are using as the best solution often varies by version. (Don’t forget to scroll down & ‘Save’)

Is this the sort of thing you are after?

24 03 21.xlsm
	A	B
1	Date	Last Bank Day
2	Monday, 22 February 2021	Friday, 26 February 2021
3	Saturday, 2 April 2022	Friday, 29 April 2022
4	Friday, 28 May 2021	Monday, 31 May 2021
5	Wednesday, 2 June 2021	Wednesday, 30 June 2021
6	Tuesday, 26 January 2021	Friday, 29 January 2021
7	Monday, 8 August 2022	Wednesday, 31 August 2022
Last Bank Day

Cell Formulas
Range	Formula
B2:B7	B2	=WORKDAY(EOMONTH(A2,0)+1,-1)

 

[scottylad2]

Thank you, and with such speed

 

[Peter_SSs]

You're welcome. Thanks for the follow-up.