If/AND formula - calendar month from today??

[weaholt]

Hope someone can help – I have been struggling with this for ages!

I have a formula with a multiple IF/AND statement incorporating dates and I just can’t get it to work.

The conditions are as follows – A1 must be greater than 0, A2 must have YES entered, A3 contains a date which must be within 1 calendar month. If these conditions are satisfied then the value from cell B1 is displayed, if they are not satisfied then the cell remains blank.

I have – =IF(AND($A1>0,A2="YES",A3>=TODAY()+28),B1,"")

The plus 28 days from today part doesn’t work because I want one calendar month. I tried calculating the start and the end of the month in 2 helper cells and then including something in the formula to day that if TODAY() is between these dates, but I get an error? It’s driving me mad!!

TIA 

 

[Kamolga]

I would replace

[LEFT][COLOR=#333333][FONT=Verdana]A3>=TODAY()+28

by

month(A3)=month(today()), year(A3)=year(today())

[/FONT][/COLOR][/LEFT]

 

[AlanY]

can use

A3>=edate(today(),1)

 

[weaholt]

So sorry - my original post should have said that A3 must be more than one calendar month from today, not within!

Thank you for responding

 

[Kamolga]

So sorry - my original post should have said that A3 must be more than one calendar month from today, not within!

Thank you for responding

Today is 13 March 2019.

A3 must be bigger or equal to 1 March 2019:

A3>=date(year(today()),month(today()),1)

A3 must be bigger or equal to 1st April 2019

A3>=date(year(today()),month(today())+1,1)

​