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]

Glad we could help & thanks for the feedback

 

[Scott Huish]

This will fix the years issue:

=IF(EOMONTH(A1,1)=EOMONTH(TODAY(),0),B1,"NA")