Calculating intervals and then counting how many occurrences using a start date

[mito44]

I am looking for a formula to calculate how many occurrences using a start date.

For example:

What I have is a start date 6/6/2013
An interval: 60 days

What I need is when I calculate the date plus the 60 days I get another date and when I add 60 days to that, I need to know Interval Question.xlsxhow many occurrences are left in 2013, 2014, and 2015?

I have numerous intervals and start dates so I need a formula to capture each and every one.

Thanks,

[JBeaucaire]

How many occurances of what? I see no data to reference in that workbook.

[MarvinP]

Hi mito and welcome to the forum,

I think you are asking a question about how many dates are between two other dates. You can change the start and end dates to whatever you like.

See if the attached gets you closer to an answer. I'm not sure exactly what you are asking but feel this CountIFS function might be what you need.

[mito44]

What I'm looking for is a count of how many occurences happen when I add the 60 days. Another example would be if I had a start date of 1/1/2013 and I had an 180 day interval and I added them both together I would get a date of 6/30/2013. I would count that as 1 occurence. If I added 180 days to that I would get a date of 12/27/2013, the second occurence. So on and so forth. So for the year of 2013, I would have 2 occurences. I hope that makes more sense. I need to know how many occurences happen for the following years based on different dates and different intervals. Thanks for your response.