Looking for a formula to calculate number of days that elapsed for 2 events

First of all I would like to thank you for reading my post.

I will try to make this sound as easy as possible.

Lets say that on the 01/01/2014 I had to make a payment. I also have to make that payment on the 01/01/2015 and 01/01/2016 and so on. However I cannot proceed with the payment of 01/01/2015 if I do not make the payment on the 01/01/2014.

This means that for the first payment 2 years and 4 months have already passed, for the second payment 1 year and 4 months have passed and for the last payment 4 months have passed.

I would like a formula that would calculate the number of total days that have passed. In the above case that means 4 years.

Any advise would be appreciated.

Thank you!

What I wantr to find in the end is the total days for each payment that should have been made added up together. I want this formula to do it for an indefinite period of time in case future payments are accrued.

Since its still April I said 4 months I only used that for the sake of the example. If you require more details please tell me.

Can you post a small sample workbook (using Go Advanced > Manage Attachments) so we can see how you have your data organized? Please alter or remove and private data.