Label Last Saturday

[IluvPivots]

Column A lists dates. How do I get Column B to label the last Saturday of the month?

 

[Ron Coderre]

With these dates in A1:A5

Tuesday, January 01, 2019
Friday, February 01, 2019
Friday, March 01, 2019
Monday, April 01, 2019
Wednesday, May 01, 2019

This regular formula, copied down, returns the last Saturday of the referenced month:

B1: =WORKDAY.INTL(EOMONTH(A1,0)+1,-1,"1111101")

Format that cell as a date.

In that example, these are the results:

Tuesday, January 01, 2019       Saturday, January 26, 2019
Friday, February 01, 2019       Saturday, February 23, 2019
Friday, March 01, 2019          Saturday, March 30, 2019
Monday, April 01, 2019          Saturday, April 27, 2019
Wednesday, May 01, 2019         Saturday, May 25, 2019

Is that something you can work with?

 

[AhoyNC]

See attached link.
https://exceljet.net/formula/get-last-weekday-in-month

Excel Workbook
	A	B
1	Date	Last Sat. in Month
2	7/9/2019	7/27/2019
3	8/2/2019	8/31/2019
4	10/23/2019	10/26/2019
Sheet

 

[IluvPivots]

Thank you!!

 

[IluvPivots]

=EOMONTH(A2,0)+1-WEEKDAY(EOMONTH(A2,0)+1-7) worked!
Many thanks!

 

[AhoyNC]

Your welcome. Thanks for the feedback.
BTW Ron's formula also worked for me.