Hello all,

I have a column which has all dates in format "4-Jan-12"(Englise US). I need to calculte in other column if the date is lies in betweem last 6 months from todays then say "Yes". e.g.
Todays date = 7-Mar-2013
Last 6 months = 6-Sept-2012
Anything lying between and equal to this date say "Yes" else "NO"

table: I want result like this

Date Derived column

4-Jan-12 NO
17-Jul-12 NO
7-Feb-12 NO
16-Aug-12 NO
11-Feb-11 NO
1-Dec-10 NO
11-Oct-12 YES
4-Mar-13 YES

Please help if. in which way shall i right a formula.