Excel 2007 : Adds values for a specific time frame

Hello,

I am having problems trying to figure out a formula that has a time delay based on an entry, and adds values for only 12 months after that.

If someone in our organization is hired in Jan, we have a savings for that person that comes into play starting 6 months later so in July. On the same line item we will have 1 person hired in Feb, so that savings starts in Aug. The savings only runs for 12 months for each person hired.

So if I assume a 100.00 savings per person and I hire 1 person in Jan 2012 and 1 person in Feb 2012, my outcome should show 0 savings from Jan 2012 thru June 2012, a 100.00 savings in July 2012, a 200.00 savings from Aug 2012 thru June 2013, a 100.00 savings in July 2013, and 0 savings from Aug 2013 onwards.

I hope this makes sense and someone can help me.