Update VBA Code to Format, Remove Unwanted Dates, and Apply Dynamic Formulas

[Justinian]

I have attached links to two spreadsheets: "Before" and "After." Here is what I am trying to do to "Before" so it ends up looking like "After."

1) If you look at the code in "Before," you will see I am trying to apply this formula to all items in column A: =RIGHT(A2,LEN(A2)-FIND("-",A2,1))
2) Once this formula is applied to column A, I need to convert all items in column A to numbers
3) Delete the remaining formulas in column G
4) Separate dates as follows: today plus 2 so if today is 8/6/19, I need the spreadsheet to only show 8/6, 8/7, and 8/18, removing all other rows and separating the three dates with a blank, unformatted row. When I run this report tomorrow (8/7/19), I need 8/7, 8/8, and 8/9 to be the only dates on the report.

I know this is a lot of extra steps but I wanted to see if anyone knows any shortcuts to accomplish this.

Before
[FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif]https://app.box.com/s/y9ek52d9dy9tmab2ny2pydo9n87jd6ye

After
[FONT=Verdana,Arial,Tahoma,Calibri,Geneva,sans-serif]https://app.box.com/s/menggrkiitjklwlniyhplvck4gbyl3jv[/FONT]_{^{<strike>
</strike>}}[/FONT]

 

[Justinian]

Bump.