How many days late is an invoice from todays date Formula
MZ Tools makes life easier for the Excel VBA coder
Thanks Thanks:  0
Likes Likes:  0
Page 1 of 2 12 LastLast
Results 1 to 10 of 11

Thread: How many days late is an invoice from todays date Formula

  1. #1
    New Member
    Join Date
    Feb 2002
    Location
    Tim
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

     
    I have a need to take a spreadsheet with the dated invoice on it and have an excel spreadsheet take todays date and the output to another cell telling me how many days old the invoice is.
    Any help would be greatly appreciated!!!!
    Thanks.
    Tim

  2. #2
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Austin, Texas USA
    Posts
    11,654
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    =TODAY()-A1 where A1 contains your invoice date.

    [ This Message was edited by: Mark W. on 2002-02-25 08:33 ]

  3. #3
    MrExcel MVP
    Join Date
    Feb 2002
    Location
    Sydney, Australia
    Posts
    2,936
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default


    =Today()-A1

    You'll need to format the cell as number.

    D

  4. #4
    New Member
    Join Date
    Feb 2002
    Location
    Tim
    Posts
    2
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    Thanks everyone for such quick responses.

    I am new to this group and you guys have made this a great first experience!!!!
    Tim

  5. #5
    Board Regular
    Join Date
    Feb 2002
    Posts
    3,169
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default

    HI

    Confused! you work from aged debt analysis (SALES LEDGER)?

    So the columns say 30day 60days tell you subjuect to billing cycle?

    else your need to apply above my chech EVERY account for invoice date and refer whats due subject to terms of sale ??? and have due adte as well to get the OVERDUE????

    HTH


    Free Excel based Web Toolbar available here.

    Jack in the UK
    J & R Excel Solutions
    "making Excel work for you"

  6. #6
    New Member
    Join Date
    Jun 2014
    Posts
    12
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: How many days late is an invoice from todays date Formula

    Hi could someone kindly provide the formula to return a value of an item overdue - but to only count Monday to Sat?

    A2 = the due date
    B2 = date overdue (Monday to Sat)

    The '=today()-a2' returns a 7 day week value.

  7. #7
    New Member
    Join Date
    Oct 2014
    Posts
    3
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: How many days late is an invoice from todays date Formula

    Quote Originally Posted by StuHendry View Post
    Hi could someone kindly provide the formula to return a value of an item overdue - but to only count Monday to Sat?A2 = the due dateB2 = date overdue (Monday to Sat)The '=today()-a2' returns a 7 day week value.
    If we want the number returns in workday value, how? ...

  8. #8
    New Member
    Join Date
    May 2015
    Posts
    25
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: How many days late is an invoice from todays date Formula

    Sorry to bring up an old thread but how could I modify that a bit so when there is nothing in the A1 cell it just displays a blank field.

    At the moment is there is nothing in the invoice date cell it gives the number 42135

  9. #9
    Board Regular
    Join Date
    Nov 2011
    Location
    San Jose, CA
    Posts
    2,277
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: How many days late is an invoice from todays date Formula

    Try:
    Code:
    =IF(A1="","",TODAY()-A1)
    Ron
    Using Excel 2013

  10. #10
    New Member
    Join Date
    May 2015
    Posts
    25
    Post Thanks / Like
    Mentioned
    0 Post(s)
    Tagged
    0 Thread(s)

    Default Re: How many days late is an invoice from todays date Formula

      
    Quote Originally Posted by RonB1111 View Post
    Try:
    Code:
    =IF(A1="","",TODAY()-A1)

    Yep, perfect. Thank you Ron!

User Tag List

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

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

 

 
DMCA.com