IF Last month

Geo1126

New Member
Joined
Apr 15, 2019
Messages
9
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
Joined
Jun 12, 2014
Messages
30,571
Office Version
365
Platform
Windows
How about
=IF(AND(A1>EOMONTH(TODAY(),-2),A1<=EOMONTH(TODAY(),-1)),B1,"N/A")
 

Momentman

Well-known Member
Joined
Jan 11, 2012
Messages
3,963
This may not work "correctly" if both dates are in different years. Or am i missing something? @ScottHuish
 
Last edited:

Geo1126

New Member
Joined
Apr 15, 2019
Messages
9
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.
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
30,571
Office Version
365
Platform
Windows
If the date in A1 was 1st Oct 2018, would you want to return the value of B1?
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
30,571
Office Version
365
Platform
Windows
In that case use the formula from post#2.
The formula from post#3 only compares the month not the year.
 

Geo1126

New Member
Joined
Apr 15, 2019
Messages
9
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.
 

Forum statistics

Threads
1,078,541
Messages
5,341,061
Members
399,414
Latest member
EMW2159

Some videos you may like

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...
Top