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-30Code_Goes_Here