Formula

[Emma@Work]

Please please help me

Sheet one holds info on Direct Debits, AMOUNT/PAYMENT DAY/START DATE/FINISH DATE.
Sheet two is a calendar with days as rows and each month from jan98-dec05 as columns.

I want to show the Payment AMOUNT in the calendar on the payment day withing the range of start date and finish date.

So I can view the calendar and forecast the Direct Debits.

I hope someone can help me,

 

[PaddyD]

On 2002-08-28 07:42, Emma@Work wrote:
Please please help me

Sheet one holds info on Direct Debits, AMOUNT/PAYMENT DAY/START DATE/FINISH DATE.
Sheet two is a calendar with days as rows and each month from jan98-dec05 as columns.

I want to show the Payment AMOUNT in the calendar on the payment day withing the range of start date and finish date.

So I can view the calendar and forecast the Direct Debits.

I hope someone can help me,

emma,

welcome to the board!

It looks like you'll need some sort of index / match combination for this. But - don't yet have enough info to go on! What happens if there are two payment dates within the range? how have you set up your date values? etc...

Perhaps you could post back with a bit more info on your data. & an example would help no end - what data you've got, what result you'd expect.

Paddy