Date Greater Than equal to and Less than equal to (Month and year)

Hi,

From the particular date i am comparing only month and Year and checking Greater than equal to answer and Less than equal to answer. Sample file attached. getting mix match answer. can you try to update with correct formula


Date1 Date3 Date3 (month and Year) >= Date1 (month and Year) Formula
25-Mar-2010 01-Dec-2014 FALSE =IF(TEXT(D4,"mmm-yyyy")>=TEXT(A4,"mmm-yyyy"),0)

Date2 Date4 Date4 (month and Year) <= Date2 (month and Year) Formula
26-May-2014 01-Jul-2016 FALSE =IF(TEXT(E3,"mmm-yyyy")>=TEXT(B3,"mmm-yyyy"),0))

Thanks...Senthil

Thanks, but not getting correct answer, when i apply formula in sample.

=(month(d3)*10000+year(d3)>=month(a3)*10000+year(d3))

04-May-2020 >= 01-Jun-2015, getting response as True, correct answer is false

=(month(e3)*10000+year(f3)<=month(b3)*10000+year(f3))

26-May-2019 <= 01-Jul-2016, getting response as False, correct answer is True

Hi ChemistB,

Thanks for your updates, In F3 formula, following scenario, i am getting error. any chance this can be fixed?
=IF(DATE(Year(E3),MONTH(E3),1)<=DATE(Year(B3), MONTH(B3),1),0,"")

Date 2 is 00-Jan-1900 (this is almost no date), date 4 has 01-Jun-2018, this scenario , i should get response as "True" or "0"

Thanks Senthil

Try

=IFERROR(IF(DATE(YEAR(E3),MONTH(E3),1)<=DATE(YEAR(B3), MONTH(B3),1),0,""),0)

=IFERROR(IF(DATE(YEAR(E3),MONTH(E3),1)<=DATE(YEAR(B3), MONTH(B3),1),0,""),"True")

Hi JohnTopley and ChemistB,

Thanks for your updates, below one has resolved.

=IF(DATE(YEAR(D3),MONTH(D3),1)>=DATE(YEAR(A3), MONTH(A3),1),TRUE,FALSE)
=IF(B3=0,TRUE,(IF(DATE(YEAR(E3),MONTH(E3),1)<=DATE(YEAR(B3),MONTH(B3),1),TRUE,FALSE)))


Thanks.. Senthil