Payments for a Certain Time - Completely Stuck

[pierce2284]

I am developing a pro-forma and need to capture different types of funding during "X" time periods. However, I am not sure the best way to do this. I am thinking an if statement but I am not sure if this would be the best approach.

As an example:

- Debt Source #1 will start in year 1 but will end in year 5, and
- Debt Source #2 will start in year 6 and end in year 12

What is the best way to tell excel to recognize Debt source #1 during years 1-5 and then switch to debt source #2?

I look forward to your help. Thank you in advance!

 

[SpillerBD]

For your dates, are you using the same data types? Are all the fields Dates or All numbers?
Occasionally I have to see the results for each part to make sure I'm getting the expected results.
If G1 is your today date value as a serial number, today is 42208 and that is likely not in your year range.....

 

[oldbrewer]

format all your dates as ddd mmm yyyy
non dates will then be evident