select Current Month

[wanass123]

Formula : 

=if(month(Resolution_Date)=month(today()),'Yes','No')

above formula give me yes for March-2022 , March 2021 , March 2020 .. 

1- I need formula for the current month only yes only with March-2022 

2- I need 2nd formula for last 3 month result should be March-2022, Feb-2022 , Jan-2022 

Please advice . 

[anat · Accepted solution]

can u try like can u try like:

=if(month(Resolution_Date)=month(today()) and year(Resolution_Date)=year(today()),'Yes','No')

[wanass123]

Thank you very much , please what about last 3 months ? 

expected result : March-2022 , Feb-2022 , Jan-2022 

[Ahamada · Accepted solution]

Try this:

1- I need formula for the current month only yes only with March-2022:

   =if(MonthName(Resolution_Date)=monthname(today()),'Yes','No')

2- I need 2nd formula for last 3 month result should be March-2022, Feb-2022 , Jan-2022 :

  =if(MonthName(Resolution_Date)>=monthname(today(),-2) and MonthName(Resolution_Date)<=monthname(today()) ,'Yes','No')