Macro to create specific Date format

[ultracyclist]

I want to create a macro that will display the weekly date format as shown in my sample data. I need to carry this down across cell ranges in column A of my worksheet. Ex: A5:A30, A35:A86, and A93:A128. I may need to adjust the ranges but once I see the macro, I can adjust it accordingly.

Additional information- Each week ends on a Friday. For months that have 5 Friday's in them I need it to show a week 5 in those months as shown in my sample data

The data range is 7/7/2017 thru 12/31/2021

Is there a macro that can do this?

Thanks,

Allen

<style type="text/css">
.tg  {border-collapse:collapse;border-spacing:0;}
.tg td{font-family:Arial, sans-serif;font-size:14px;padding:10px 5px;border-style:solid;border-width:1px;overflow:hidden;word-break:normal;}
.tg th{font-family:Arial, sans-serif;font-size:14px;font-weight:normal;padding:10px 5px;border-style:solid;border-width:1px;overflow:hidden;word-break:normal;}
.tg .tg-yw4l{vertical-align:top}
</style>
[TABLE="class: tg"]

  <tbody>[TR]

    [TH="class: tg-yw4l"]Month 2 Week 1- 8/4/2017[/TH]

  [/TR]

  [TR]

    [TD="class: tg-yw4l"]Week 2- 8/11/2017[/TD]

  [/TR]

  [TR]

    [TD="class: tg-yw4l"]Week 3- 8/18/2017[/TD]

  [/TR]

  [TR]

    [TD="class: tg-yw4l"]Week 4- 8/25/2017[/TD]

  [/TR]

  [TR]

    [TD="class: tg-yw4l"]Month 3 Week 1 -9/1/2017[/TD]

  [/TR]

  [TR]

    [TD="class: tg-yw4l"]Week 2- 9/8/2017[/TD]

  [/TR]

  [TR]

    [TD="class: tg-yw4l"]Week 3- 9/15/2017[/TD]

  [/TR]

  [TR]

    [TD="class: tg-yw4l"]Week 4- 9/22/2017[/TD]

  [/TR]

  [TR]

    [TD="class: tg-yw4l"]Week 5- 9/29/2017[/TD]

  [/TR]

</tbody>[/TABLE]

 

[JLGWhiz]

The revised macro is working perfect. Thank you again for responding to my updated post.

You're welcome,
regards, JLG