monthly payments in weekly model

[Kaps_mr2]

hello,

i am trying to allocate monthly payments into a weekly model e.g the salary is paid on the 1st of the month but the columns are weekly. So in the sheet below, on row 20, the salary which is stored in the cell 'Assumptions'!b35 should only appear in the weeks that include the first of the month (which is specified in cell Assumption C35). can anyone see what can be done ? Thanks

Kaps

 

[Fluff]

Change the 1st < to >= & also change the 2nd < to <=

 

[Kaps_mr2]

like below - but that puts it in every column - i only want it in the respective columns

 

[Fluff]

You also need to swap the 2nd part of the and around so its day(c4)<= etc

 

[Kaps_mr2]

thanks. i'm still not getting what i expect

 

[Fluff]

In that case can you post some sample data using the XL2BB add-in.