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

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

Hi,
I am not able to fully understand the criteria since I am in hurry now,
have a look at the below formula

PHP Code: 

=EDATE(A1,6) 


Assuming you have the event date in A2 and the start of the current year in B2 - you can either just type that in or make it dynamic by using this formula

=DATE(YEAR(TODAY()),1,1)

Then in D2 use this formula for the date in the first half of the year

=LOOKUP(10^9,IF({1,0},0,EDATE(A2,FLOOR(DATEDIF(A2,B2-1,"m"),6)+6)))

custom format that cell as d/m/yy;; [the two semi-colons ensure that it shows as blank if there is no valid date]

and for E2 use this version:

=LOOKUP(10^9,IF({1,0},0,EDATE(A2,FLOOR(DATEDIF(A2-1,EDATE(B2-1,6),"m"),6)+6)))

formatted the same way