Return value based on date range

I am trying to assign custom Month value to a DATE based on the criteria if the date falls in between Start and End Date.

Criteria:
Start Date End Date Custom Month Value
1/6/2014 2/2/2014 Jan-14
2/3/2014 3/2/2014 Feb-14
3/3/2014 4/6/2014 Mar-14
4/7/2014 5/4/2014 Apr-14
5/5/2014 6/1/2014 May-14

Desired Output:
DATE Custom Month Value
1/11/2014 Jan-14
3/1/2014 Feb-14
5/4/2014 Apr-14

The Criteria date ranges from 2000 to 2015.

Would appreciate any advise on an optimal approach to achieve these results (without using if-else).

Many Thanks

Thank you Martin for your suggestion, this definitely is a good option.

However, my date ranges are from 2000 to 2015 and i will have to spell out 180 conditions to achieve this result. Could there be possibly a shorter way to achieve this.

I do have a pattern in the date ranges: the no. of days b/w start date and end date for different months is as follows: 28, 28, 35, 28, 28, 35, 28, 28, 35, 28, 28, 35 (i.e. Mar, Jun, Sep, Dec have 5 weeks all other months have 4 weeks)

Thanks again

Thanks for your response AlKey, do I apply this as an array formulae? Does not seem to be working. The Criteria table is my example is a table that defines the criteria. I need the output in another table referencing Date.

Originally Posted by AlKey

Maybe formula solution

=IF(AND(A2>=B2,B2<=A2),"",EDATE("1/14/2014",ROW($A1)-1))

	A	B	C
1	Srart Date	End Date	Custom format: mmm-yy
2	1/6/2014	2/2/2014	Jan-14
3	2/3/2014	3/2/2014	Feb-14
4	3/3/2014	4/6/2014	Mar-14
5	3/3/2014	4/6/2014	Apr-14
6	4/7/2014	5/4/2014	May-14
7	5/5/2014	6/1/2014	Jun-14