Need help in identifying dates

[aryanaveen]

Hi All,

Can you please help me in writing a formula for below scenario

I need a formula which will refer to dates in column A and if the date falls in current month or previous month then status in column B should be updated as "Open", if the dates falls anything other than current month or previous month then status in column B should be "closed"

	A	B
1​	Date	Status	Current date
2​	16-Jul-20​		16-Jul-20​
3​	16-Jun-20​
4​	6-Jul-20​
5​	16-Jun-20​
6​	16-Mar-20​
7​	26-Mar-20​
8​	5-Jan-20​
9​	16-Feb-20​
10​	16-Aug-20​

 

[Yongle]

Try this

=IF(AND(A2>EOMONTH(TODAY(),-2),A2<=EOMONTH(TODAY(),0)),"Open","Closed")

 

[aryanaveen]

Thank you Yongle, this is exactly what I was looking

 

[Yongle]

thanks for your feedback