Good day

I urgently need help with a formula for dates, when I have a cutoff date (20171130) the invoice date the user enters should populate a "X" in either the 30-day column or a "X" in the 30DayPlus-column.

The formula that I am using is

=IF(ISBLANK(A3)," ",IF(A3>D3,"X"," ")) for the 30 day column

and for the 30DayPlus column I am using

=IF(ISBLANK(A3)," ",IF(A3<=D3,"X"," "))

This is not working correctly because when my cuttoff date is 20171130 and my invoice date is 20171101 the "X" should be in the 30Day column.

I hope this make sense. It is for a accruals list that I need this(see below). The bold lines are then incorrect.

Accruals Cutoff: 2017-11-30 2017-11-30 Invoice Date 30 Days (mark with X) 30 Days + (mark with X) 2017-11-30 2017-09-30 X 2017-11-30 2017-09-02 X 2017-11-30 2016-10-10 X 2017-11-30**2017-11-05**

**X**2017-11-30 2016-11-30 X 2017-11-30 2017-09-20 X 2017-11-30 2017-09-29 X 2017-11-30 2017-10-01 X 2017-11-30

**2017-11-01**

**X**2017-11-30 2017-12-01 X 2017-11-30

`Code_Goes_Here`