Two data sets, with different dates - Want to match so dates connect

[luckej]

So i have two dataset.
1. Daily data
2. Weekly data

I would like to match the data so the weekly data are on the same row when the dates are the same as daily.
Can this be done? And how?

If this can be done, is it now possible to delete all the daily data that doesn't have a matching weekly date?

Thanks for any respons

[Olly]

Attach a sample workbook (not a picture or pasted copy). Make sure there is just enough data to demonstrate your need. Include a BEFORE sheet and an AFTER sheet in the workbook if needed to show the process you're trying to complete or automate. Make sure your desired results are shown, mock them up manually if necessary.

Remember to desensitize the data.

Click on GO ADVANCED and then scroll down to Manage Attachments to open the upload window.

[José Augusto]

Try this formula

Please Login or Register  to view this content.

where Tabela2 is the Weekly table.

See the file