Excel Date greater than another date

italy16

New Member
Joined
May 9, 2014
Messages
34
Hello everyone - I'm trying to input an If statement that says if date XXX PLUS 30 days is greater than date YYY, if true say "good", if false "Not good")

For example
cell A1 = 12/3/18
cell B1 = 12/15/18

So if cell B1 Plus 30 days (1/15/19) is greater than cell A1.....
 

Some videos you may like

Excel Facts

Do you hate GETPIVOTDATA?
Prevent GETPIVOTDATA. Select inside a PivotTable. In the Analyze tab of the ribbon, open the dropown next to Options and turn it off

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
46,303
Office Version
  1. 365
Platform
  1. Windows
How about
=IF(B1+30>A1,"good","not good")
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
46,303
Office Version
  1. 365
Platform
  1. Windows
Alternatively if you want B1 +1month try
=IF(EDATE(B1,1)>A1,"good","not good")
 

italy16

New Member
Joined
May 9, 2014
Messages
34
Slightly similar question - how would I say if the date in cell B1 is within 1 month of the date in cell a1?
 

Fluff

MrExcel MVP, Moderator
Joined
Jun 12, 2014
Messages
46,303
Office Version
  1. 365
Platform
  1. Windows
Is this what you mean?
=IF(AND(A1<=B1,EDATE(A1,1)>=B1),"good","not good")
 

Watch MrExcel Video

Forum statistics

Threads
1,108,971
Messages
5,525,967
Members
409,673
Latest member
Riseee

This Week's Hot Topics

Top