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

1. ## Invoice "Current" or "Overdue" (but need "Paid" option)

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.

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

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.

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

Try this

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

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

Hello rwatson,

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

Should work.

Thanks!

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

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

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

Np rwatson.

Dont forget to mark this thread as complete.

##### Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

#### Posting Permissions

• You may not post new threads
• You may not post replies
• You may not post attachments
• You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1