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