IF Last month

[Geo1126]

Hi Guys,

I think this is pretty basic, yet I still havent been able to figure it out.

I want a formula that returns a cell value, if another cell value (date) occured last month. if the month column is blank or not last month return NA.

A1 has date
B1 has value I wanted formula to capture
C1 has formula I'm looking for.

I know its something obvious I'm over looking. Please any assistance will be greatly appreciated.

 

[Fluff]

How about
=IF(AND(A1>EOMONTH(TODAY(),-2),A1<=EOMONTH(TODAY(),-1)),B1,"N/A")

 

[Scott Huish]

How about:
=IF(MONTH(EOMONTH(A1,1))=MONTH(TODAY()),B1,"NA")

 

[Momentman]

This may not work "correctly" if both dates are in different years. Or am i missing something? @ScottHuish

 

[Geo1126]

I love you both. They both work.

Thanks.

I was closer to Scotts, I didnt have the "" wrapped around the NA, and was getting a #name ? error.

 

[Geo1126]

This may not work "correctly" if both dates are in different years. Or am i missing something? @ScottHuish

I added it to my sheet, and found no errors going back a few years. thanks for looking out tho!

 

[Fluff]

If the date in A1 was 1st Oct 2018, would you want to return the value of B1?

 

[Geo1126]

If the date in A1 was 1st Oct 2018, would you want to return the value of B1?

No

 

[Fluff]

In that case use the formula from post#2.
The formula from post#3 only compares the month not the year.

 

[Geo1126]

Thanks again fluff... yours is the one i went with. Works great. I did test scott's but I didnt review back to a prior year.

Good catch by both you and Momentman.