Results 1 to 5 of 5

A4 date of invoice - E4 invoice status - F4 Date invoice was paid - G4 number of days invo

Threaded View

Prydien A4 date of invoice - E4... 10-31-2012, 06:05 PM
oeldere Re: New to Excel bit off more... 10-31-2012, 06:18 PM
dredwolf Re: New to Excel bit off more... 10-31-2012, 06:39 PM
BeachRock Re: New to Excel bit off more... 10-31-2012, 06:39 PM
Prydien Re: New to Excel bit off more... 11-04-2012, 12:43 PM
  1. 10-31-2012, 06:39 PM #4
    BeachRock is offline
    Forum Contributor BeachRock's Avatar
    Join Date
    11-01-2011
    Location
    Oregon, United States
    MS-Off Ver
    Excel 2016
    Posts
    403

    Re: New to Excel bit off more than I can chew

    Hi Prydien,

    Put this formula into your E4 cell: =IF(F4>0,"Paid",IF(AND(A4<TODAY()-60,F4=""),"Overdue"))

    Copy and paste formula down.

    Put this formula into your G4 cell: =IF(A4="","",IF(A4<TODAY()-60,TODAY()-A4))

    Copy and paste formula down.



    EDIT: I did test mine and it seems to work fine.
    Last edited by BeachRock; 11-01-2012 at 08:45 AM. Reason: Slight change to G4 formula for nothing in A4
    -------------
    Tony
    Reply With QuoteRegister To Reply
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Bookmarks

Posting Permissions

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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1