+ Reply to Thread
Results 1 to 3 of 3

Aging Function

Hybrid View

hrhusker Aging Function 05-18-2005, 10:43 AM
Alex Delamain If the invoice date is in... 05-18-2005, 10:47 AM
hrhusker Aging Function (another... 05-19-2005, 09:38 AM
  1. #1
    Registered User
    Join Date
    07-01-2004
    Location
    Kent, UK
    Posts
    74
    If the invoice date is in column A and the amount outstanding in column B then in col C

    =IF(B1>0,+TODAY()-A1,"")

  2. #2
    Registered User
    Join Date
    05-18-2005
    Posts
    3

    Aging Function (another question)

    Thank you very much for the previous formula, it worked perfectly!

    Now that I have the number of days an invoice is late, I need to move them to another section of the worksheet that breaks it down between current, 30 days, 60 days, 90 days and 120+. I also need it to add the amount due for each amount past due.

+ Reply to 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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1