Hi, Thanks for assisting with this as a bit lost. I'm trying to project a dollar amount forward in a cash flow project. Key points with an example are as follows: I have a $1000 outflow to occur every fortnight. I have tabled the start date and then every 14 days the payment is to reoccur. So I have created a row of dates where the payment will fall upon. I have a data schedule that I wish to populate with these corresponding dates/amounts. i.e. if payment occurs between the upper and lower data (within the week), I would like the $1000 to be displayed in the scheduled (3) I'm not sure the best formula or easiest way to outlay the data and would appreciate the help Thanks Ro

If you would like to post, please check out the MrExcel Message Board FAQ and register here. If you forgot your password, you can reset your password.

Cashflow Projection - Display Amount Between Two Dates

Thread starter Rohmeo
Start date Mar 28, 2019
Tags

amount data dates payment project

Rohmeo

New Member

Mar 28, 2019

Hi,

Thanks for assisting with this as a bit lost. I'm trying to project a dollar amount forward in a cash flow project.

Key points with an example are as follows:

I have a $1000 outflow to occur every fortnight.
I have tabled the start date and then every 14 days the payment is to reoccur. So I have created a row of dates where the payment will fall upon.
I have a data schedule that I wish to populate with these corresponding dates/amounts. i.e. if payment occurs between the upper and lower data (within the week), I would like the $1000 to be displayed in the scheduled (3)

I'm not sure the best formula or easiest way to outlay the data and would appreciate the help

Thanks
Ro