Need help writing Loop syntax

Hi Everyone,

I am limited in coding using macros/vba for excel, so would greatly appreciate if someone could help me with the syntax. Here is what I need, and sample data attached:

Loop
Length - run until the end of data in column A

Test#1
Starting with "MAY 04", I want to run a loop that checks "MAY 04" against every month in the same row to see if there is data present in both months on the same date. If YES, then return the two header rows in the format "MAY 04^JUN 04".

Then repeat this loop for each of the months in the header row from left to right...i.e, "JUN 04" against "JUL 04", "AUG 04", "SEP 04", etc. "JUL 04" against "AUG 04", "SEP 04", "OCT 04", etc.

Continue this loop until all the months in the header row have been checked.

Output
The final output would be a list of all the months with data present on the same date (duplicates removed)

Have a look at the attached spreadsheet, I think I have the test criteria for the loop that will work.

SampleData1.xlsx