Invoice "Current" or "Overdue" (but need "Paid" option)

**rwatson** · 04-05-2012, 11:59 AM

This is the formula I have which works with invoice due date compared to todays date.

=IF(J13="","",(IF((TODAY()-J13)>0,"Overdue","Current")))

J13 is the payment due date.

In cell K13 I have will input the actual payment date. Is there a way that one I have inputed data into K13 it will change the formula to say "Paid"

??

R.

**bonny24tycoon** · 04-05-2012, 12:08 PM

Hi rwatson,

Try this

Please Login or Register  to view this content.

If I was able to help PLEASE DO NOT FORGET to click the small star icon at the bottom left of my post.

**Down Under** · 04-05-2012, 12:10 PM

Try this

=if(j13="","",if(k13="",(if(today()-j13)>0,"Overdue","Current")),"paid")

**rvasquez** · 04-05-2012, 12:12 PM

Hello rwatson,

=IF(J13="","",IF(K13>0,"PAID",IF((TODAY()-J13)>0,"Overdue","Current")))

Should work.

Thanks!

**rwatson** · 04-05-2012, 12:13 PM

Thanks guys, tried bonny's one first and it worked a treat.

**bonny24tycoon** · 04-05-2012, 12:16 PM

Np rwatson.

Dont forget to mark this thread as complete.

Have a nice day ahead. Adios..

Invoice "Current" or "Overdue" (but need "Paid" option)

LinkBack

Thread Tools

Rate This Thread

Display

Invoice "Current" or "Overdue" (but need "Paid" option)

Re: Invoice "Current" or "Overdue" (but need "Paid" option)

Re: Invoice "Current" or "Overdue" (but need "Paid" option)

Re: Invoice "Current" or "Overdue" (but need "Paid" option)

Re: Invoice "Current" or "Overdue" (but need "Paid" option)

Re: Invoice "Current" or "Overdue" (but need "Paid" option)

Thread Information

Users Browsing this Thread

Bookmarks

Bookmarks

Posting Permissions