Compare (divide) cells if Date in corresponding cells are equal?

[maramsey]

Sorry for the horribly worded title, i couldn't think of how to put it into words

I have two sets of data to compare. One is real world data, the other is forecasted data. I have real daily data for every day over about 3 months. The predictions though, there may be 4-6 predictions for ever one real daily value.

What I'd like to do is have a function that looks at Column A's date (real daily value) and Column C's date (predicted data) and if Column C equals Column A, then divide corresponding data in Column B by value in Column D.

Is this possible?

[etaf]

are these comparisons of the same row ?

if so

If( A2=C2, B2/D2, "what to do if the dates are not equal")

otherwise can we see a sheet and maybe some examples of the cells and out put required

[maramsey]

Sadly, no it's spread out, thus the need for a function of some sort. See spreadsheet

Also, I realize that the data in the spreadsheet has the date/time in the same cell in Column C. I do know how to separate those.