if Condition match with Date function

Hi Senthile, looking at your formula, this is how I follow it:-
Step 1 If month in column A is less than October then produce text with "month number-year", if month is greater then September, produce FALSE
Step 2 Then take output of above and if >="06-2018" give a rounded number 0.5% of column B, otherwise produce text again as in step 1
Step 3 Then take output of above and if >="04-2017" give a rounded number 0.65% of column B, otherwise produce text again as in step 1
Step 4 Then take output of above and if >="02-2015" give a rounded number 0.65% of column B, otherwise produce text again as in step 1
Step 5 Then take output of above and if <="01-2015" give a rounded number 1.1% of column B, otherwise leave as FALSE

I'm not sure why it looks to see if it's earlier than October and is a little cumbersome. I've come up with a much simpler formula that uses your dates as a lookup table instead. It gives all the correct values as per your sample except row 48 (Which I believe was an oversight in your "correct answers").

Resort your table A2:B5 to put the highest date and associated percentage first

then use

=LOOKUP(2,1/(A8<=A$2:A$5),B$2:B$5)