Thanks:  0
Likes:  0

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

1. 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. =TODAY()-A1 where A1 contains your invoice date.

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

3. =Today()-A1

You'll need to format the cell as number.

D

4. Thanks everyone for such quick responses.

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

5. 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

6. ## 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. ## Re: How many days late is an invoice from todays date Formula

Originally Posted by StuHendry
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. ## 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. ## Re: How many days late is an invoice from todays date Formula

Try:
Code:
`=IF(A1="","",TODAY()-A1)`

10. ## Re: How many days late is an invoice from todays date Formula

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

Yep, perfect. Thank you Ron!

## User Tag List

#### Posting Permissions

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