[image] Dorothy_lee 1d Hello, all I’m struggling to set Macro for finding Last Fri “mmdd” format sheet name. My Logic is if today is Tuesday(Main sheet is “0511”), it has to refer Last Friday sheet(Name:0507) Can I set with Macro script? [image] [image] [txt] Sub Macro21() shtName = Form…

How to select every last Friday date with MMdd format?

lkmoore70 (Logan) July 22, 2021, 8:44pm 2

Sure. The VBA code for last Friday as MMDD is: Format(Now - (Weekday(Now(), vbFriday) - 1), “mmdd”)

Topic		Replies	Views
[Macro Inquiry] How to find every last Friday with MMdd format in excel macro? Activities excel , uiautomation , activities , question	7	945	May 13, 2021
[Macro Inquiry] How to set last Friday date format in excel? Activities excel , activities , question	0	675	May 9, 2021
Determine the Last Friday of each Month? Activities uiautomation	11	1510	November 18, 2021
Obtain last Friday's date based on today's date Help activities	9	5532	January 10, 2023
Find last sundays of the month in macros Academy Feedback excel , uiautomation , studio , question	10	3820	March 13, 2020