#### Geo1126

##### New Member

- Joined
- Apr 15, 2019

- Messages
- 9

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.