+ Reply to Thread
Results 1 to 2 of 2

Aging of the invoice from its due date

  1. 07-15-2014, 01:01 PM #1
    bimbostarr
    bimbostarr is offline
    Registered User
    Join Date
    07-15-2014
    Location
    Makati City
    MS-Off Ver
    Excell Workbook
    Posts
    1

    Smile Aging of the invoice from its due date

    Can someone please help me how to calculate the exact number of aging of an invoice from its due date?

    Appreciate the help!
    Reply With QuoteRegister To Reply
  2. 07-15-2014, 01:02 PM #2
    Ace_XL
    Ace_XL is offline
    Forum Expert Ace_XL's Avatar
    Join Date
    06-04-2012
    Location
    UAE
    MS-Off Ver
    2016
    Posts
    6,074

    Re: Aging of the invoice from its due date

    Try

    =TODAY()-A1

    where Cell A1 contains due date
    Life's a spreadsheet, Excel!
    Say thanks, Click *
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. count data using most recent date and aging
    By olympiaa2010 in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 01-29-2014, 02:56 PM
  2. [SOLVED] Save invoice to folder by month and then save file by date and invoice
    By Val777 in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 07-03-2013, 02:57 AM
  3. Invoice Aging spreadsheet Formula for 120+ days see attachment
    By ncmbilling in forum Excel Formulas & Functions
    Replies: 2
    Last Post: 11-09-2012, 12:30 PM
  4. A4 date of invoice - E4 invoice status - F4 Date invoice was paid - G4 number of days invo
    By Prydien in forum Excel Formulas & Functions
    Replies: 4
    Last Post: 11-04-2012, 12:43 PM
  5. A/P aging with date in IF statement
    By rbray in forum Excel - New Users/Basics
    Replies: 1
    Last Post: 01-04-2010, 06:47 PM

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