[SOlVED]LookUp and asign value to the right weeks

[jackson_hollon]

Hello Everyone,

I am trying to figure out which formulas should be used in order to get what I want. I am trying to convert a forecast from monthly to weekly. I have the following criterias:

Loan Pay first day of month
Credit Card Pay first day of following month
IT Agreement Pay on the 19th of every month
Cell Phone Pay on the 20th of following month
Insurance Pay on the 26th of every month
Rent Pre-Pay on last day of prior month
Royalty Pay Quarterly of 1st day of the 4th month


I had learned a lot here about LookUp, so I came up with the formula as follow for the loan:

=IF(OR(AND(DAY(D13+2)<=1,DAY(D13+7)>1),AND(DAY(D13)<=1,DAY(D13+7)>1)),LOOKUP(D13-7,'Sheet 1'!$1:$1,('Sheet 1'!$2:$2)),0)

But it doesn't work.

It will be greatly appreciated if someone can give me some hand.

Thanks.

Jackson