Increment Dates by 6 months until result falls in between two date values and return resul

[sdavison]

Hello again my friends,

It's off to another project after you all got me through the last one. Thanks to all who assisted. The task in front of me seems like it's easy enough, however, I think I'm either just not seeing the solution, or have not gotten into the required functions deep enough. I have a date of an event in the past (a couple of weeks to several years) and would like to return a 6 month multiple of that date once it reaches set criteria (halves of the current year). If the event happened on 3/12/09, then the desired result would be 3/12/13 (First half of this year) and 9/12/13 (Second half of this year). If the event happened 4/1/13, then the desired result would be blank for first half of this year (not having reached the 6 month increment) and 10/1/13 for the second half of this year. There is no need to list every multiple of the date, just the ones that meets the criteria.

I would upload a sample worksheet, but at the moment it contains just the 3 dates (event date, start of current year, and end of current year). I have tried to clarify what I am trying to get excel to do and Google has been of little help. So I turn to a more specialized option.

Thank you all for your assistance,

Scott