# Excel Date greater than another date

#### italy16

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

### 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
=IF(B1+30>A1,"good","not good")

#### Fluff

##### MrExcel MVP, Moderator
Alternatively if you want B1 +1month try
=IF(EDATE(B1,1)>A1,"good","not good")

Thank you!!!!

#### italy16

##### New Member
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
Is this what you mean?
=IF(AND(A1<=B1,EDATE(A1,1)>=B1),"good","not good")

Replies
4
Views
79
Replies
1
Views
81
Replies
2
Views
41
Replies
4
Views
83
Replies
15
Views
186