Enter correct values in non contiguous cells depending on frequency.

Budget.xlsx

Hi There

I am preparing a worksheet to track several months of budget numbers June 11 - Dec 11...Pls see attached.

As you can see from the attachment income and or expenses can occur weekly, fortnightly or monthly. The weekly and monthly numbers are easy to enter and have worked out formulas to get the values in the appropriate cells by searching for the day of the week (mon, tue, wed...etc) or the day of the month (1, 2 , 3 etc....)

The part I am having trouble with is working out how to get an income / expense value which occurs fortnightly to appear automatically in the correct cells of the corresponding row depending on first occurrence (i.e. first occurence is 01/06/11 and then every 14 days after that until 31/12/11).

I would like the formula to reference the frequency chosen in the frequency column (i.e weekly frequency would cause the value to appear every seven days, forthnightly would appear every 14 days and monthly would appear on same day of every month i.e 25th of the month

Any help you guys can offer would be greatly appreciated.

Cheers

Chris