# IF Last month

#### Geo1126

##### New Member
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

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

#### Scott Huish

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

#### Momentman

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

Last edited:

#### Geo1126

##### New Member
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

##### New Member
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

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

#### Geo1126

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

#### Fluff

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

#### Geo1126

##### New Member
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.

Threads
1,078,435
Messages
5,340,250
Members
399,361
Latest member
Linford

### This Week's Hot Topics

• Problem with Radio Button's format control
I am creating an employee evaluation template (a sample is below) Column A is the category Column B, C D, E and F will be ratings (unacceptable...
• Last Display on userform to a Listbox
[CODE=vba] lstdisplay.ColumnCount = 15 lstdisplay.RowSource = "A1:O600000" [/CODE] So when i do this it Displays everything on the sheet i am...
• Rename and move files to a new location
Dear all, I have an excel file with the following information. The actual file name is at column A but i want to rename it using the following...
• Help with True/False Formula
Hello! Am stumped how to fix this formula, in which my result returns 'True', but it should return False. =IF(AG2=True...
• Clear extra characters from a provided range of cells
Dear All, I have following code which gives me desired output to remove extra characters from a provided range. But it takes too much time when...
• Help with Current and highest streaks
Hi there, I've just joined the forum and this is my first post. I've already spent quite a bit of time searching the net and this forum for a...