View Single Post
  #4   Report Post  
CptnRsk CptnRsk is offline
Junior Member
 
Posts: 1
Default

Quote:
Originally Posted by CRAIGJACK View Post
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

Last edited by CptnRsk : June 3rd 14 at 07:26 AM