Thanks for your time and effort with this questions.
I'm planning a budget for the next three years (retire) and I have an expense, I pay every 3 months.
Row 5 - Has date headings for 3 years starting in column "E", and continuing for 1100 or so columns.
Row 6 - Column "a" description of expense... column "b" the date example ( Dec 1, 2017) I pay the expense... column "c" the amount (200) of the expense... column "d" how often, so I have a 3 there (every three Months) I have the expense.
I need a formula where it looks at the date in column b - Dec 1 2017, finds the date in row 5, then returns the amount 200 in row 6, under the date. From that point then it enters the 200 every 3 months, so next date to pay would be March 2, and 200 would be in row 6 displayed, under the column heading March 1, and continuing so forth every 3 months, for next three years.
Again thanks for your help, and have great day.
I'm planning a budget for the next three years (retire) and I have an expense, I pay every 3 months.
Row 5 - Has date headings for 3 years starting in column "E", and continuing for 1100 or so columns.
Row 6 - Column "a" description of expense... column "b" the date example ( Dec 1, 2017) I pay the expense... column "c" the amount (200) of the expense... column "d" how often, so I have a 3 there (every three Months) I have the expense.
I need a formula where it looks at the date in column b - Dec 1 2017, finds the date in row 5, then returns the amount 200 in row 6, under the date. From that point then it enters the 200 every 3 months, so next date to pay would be March 2, and 200 would be in row 6 displayed, under the column heading March 1, and continuing so forth every 3 months, for next three years.
Again thanks for your help, and have great day.
