Formula w/ Arrays

I download data and I need it to flow over to a summary tab based on a 4 digit number being contained in a cell.

The first part I need help with is that the date I download (see Download tab column A) is in a General format. Is there an easy way to change this so I can match it up to what is in my column A of my Disb08 tab?

I have the formula down for my REC08 tab, I just need help with the Disb08 formulas.

I need to flow from the Download tab to the Disb08 tab based on the date, that column F of the Download tab = "Outgoing Money Transfer" and that the 4 digit number in in row 2 of the Disb08 tab is matched against Column G in the Download tab. When all those match, then the value from column J of the download tab would flow over.

Please let me know if you need anything clarified.

thank you for your help.