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,247
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,247
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,247
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,077,828
Messages
5,336,621
Members
399,093
Latest member
chado4250

Some videos you may like

This Week's Hot Topics

Top