Quote:
Originally Posted by CRAIGJACK
Ok thank you,
but now what if there are mutiple dates in Column E?
will the formula be:
=AND((E$3$-TODAY())<=30,(E$3$-TODAY())=0) ?
|
Hi, I am new to excel formulas and could use some help with this and my idea/logic....
I was able to get this to work, but I want a third option. Basically like this.
If more than 30 days to due date = Paid
If less than 30 days to due date = Due
If date equal to due date +1 = Overdue..
I have it working with =IF((Status!B2-TODAY())=30,K1,L1)
K1 = Paid
L1 = Due
J1 = Overdue
I played with it a little bit and came up with =IF((Status!B2-TODAY())=30,K1,L1)&IF((Status!B2-Today())<1,J1,K1)
And I tried this =IF((Status!B2-TODAY())=30,K1,L1)&IF((Status!B2-Today())=+1,J1) But shows DueOverdue
As you can see it shows two entries. It as if it still shows the result of the caluclation based on the original 30 days argument.
Any help to get the third option of J1, to be a viable argument in this formula would be much appreciated.
Thanks
Cptn