Past 2 weeks weather

[shophoney]

Hi I'm trying to display the last 2 weeks weather and the next weeks forecast in my worksheet.

I've tried to use power query to select just the forecast. But I'm having difficulty finding a website that displays either items that i can use.

I was able to find this:[TABLE="width: 622"]
<colgroup><col><col><col><col><col><col><col><col></colgroup><tbody>[TR]
[TD]Day[/TD]
[TD]Description[/TD]
[TD]High / Low[/TD]
[TD]Precip[/TD]
[TD]Wind[/TD]
[TD]Humidity[/TD]
[TD]Column7[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Tonight

APR 25[/TD]
[TD]Showers Early[/TD]
[TD]--8°[/TD]
[TD="align: right"]0.3[/TD]
[TD]ENE 31 km/h[/TD]
[TD="align: right"]0.86[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Wed

APR 26[/TD]
[TD]Partly Cloudy[/TD]
[TD]13°9°[/TD]
[TD="align: right"]0.2[/TD]
[TD]ENE 20 km/h[/TD]
[TD="align: right"]0.84[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Thu

APR 27[/TD]
[TD]PM Thunderstorms[/TD]
[TD]18°10°[/TD]
[TD="align: right"]0.8[/TD]
[TD]ENE 21 km/h[/TD]
[TD="align: right"]0.84[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Fri

APR 28[/TD]
[TD]Partly Cloudy[/TD]
[TD]14°8°[/TD]
[TD="align: right"]0.1[/TD]
[TD]SSW 24 km/h[/TD]
[TD="align: right"]0.65[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Sat

APR 29[/TD]
[TD]Partly Cloudy[/TD]
[TD]14°7°[/TD]
[TD="align: right"]0.2[/TD]
[TD]NNW 19 km/h[/TD]
[TD="align: right"]0.6[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Sun

APR 30[/TD]
[TD]Rain/Wind[/TD]
[TD]9°9°[/TD]
[TD="align: right"]0.7[/TD]
[TD]E 34 km/h[/TD]
[TD="align: right"]0.71[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Mon

MAY 1[/TD]
[TD]Thunderstorms/Wind[/TD]
[TD]13°9°[/TD]
[TD="align: right"]0.8[/TD]
[TD]S 32 km/h[/TD]
[TD="align: right"]0.91[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Tue

MAY 2[/TD]
[TD]Partly Cloudy[/TD]
[TD]12°6°[/TD]
[TD="align: right"]0.2[/TD]
[TD]WSW 31 km/h[/TD]
[TD="align: right"]0.63[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Wed

MAY 3[/TD]
[TD]AM Showers[/TD]
[TD]11°7°[/TD]
[TD="align: right"]0.5[/TD]
[TD]WNW 25 km/h[/TD]
[TD="align: right"]0.66[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Thu

MAY 4[/TD]
[TD]Showers[/TD]
[TD]11°6°[/TD]
[TD="align: right"]0.6[/TD]
[TD]WNW 26 km/h[/TD]
[TD="align: right"]0.71[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Fri

MAY 5[/TD]
[TD]Mostly Cloudy[/TD]
[TD]10°5°[/TD]
[TD="align: right"]0.2[/TD]
[TD]NNW 24 km/h[/TD]
[TD="align: right"]0.67[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Sat

MAY 6[/TD]
[TD]Mostly Sunny[/TD]
[TD]13°8°[/TD]
[TD="align: right"]0.2[/TD]
[TD]NE 18 km/h[/TD]
[TD="align: right"]0.63[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Sun

MAY 7[/TD]
[TD]Partly Cloudy[/TD]
[TD]14°8°[/TD]
[TD="align: right"]0.2[/TD]
[TD]NE 18 km/h[/TD]
[TD="align: right"]0.68[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Mon

MAY 8[/TD]
[TD]Showers[/TD]
[TD]15°9°[/TD]
[TD="align: right"]0.6[/TD]
[TD]NE 19 km/h[/TD]
[TD="align: right"]0.64[/TD]
[TD][/TD]
[/TR]
[TR]
[TD][/TD]
[TD]Tue

MAY 9[/TD]
[TD]Partly Cloudy[/TD]
[TD]16°9°[/TD]
[TD="align: right"]0.2[/TD]
[TD]ENE 15 km/h[/TD]
[TD="align: right"]0.63[/TD]
[TD][/TD]
[/TR]
</tbody>[/TABLE]



Thanks