Formula for Aging in days

Thanks:  0
Likes:  0

Thread: Formula for Aging in days

1. Formula for Aging in days

HI...can anyone help me with a formula for aging data in days (to be aged based on current date vs. for eg., Invoice date)

2. Re: Formula for Aging in days

Welcome to the board...

If A1 = Invoice Date

=TODAY()-A1

3. Re: Formula for Aging in days

Thanks Jonmo1 - was looking for more comprehensive formula like - we have the aging days based on ur formula below. How do we split it further in ranges of say 0-30 days, 31-60 days, 61-90 days, 91-120 days and > 120 days (data to be split based on aging days into different columns using either IF formula specifying ranges...?)

4. Re: Formula for Aging in days

Originally Posted by dominic_aca
Thanks Jonmo1 - was looking for more comprehensive formula like - we have the aging days based on ur formula below. How do we split it further in ranges of say 0-30 days, 31-60 days, 61-90 days, 91-120 days and > 120 days (data to be split based on aging days into different columns using either IF formula specifying ranges...?)
Well, you didn't say that. All I got from the original post is, how to find the number of days between Invoice Date and Today's date...

But anyway...

You can try lookup

If B1 is your basic =TODAY()-A1

Then you can use Lookup

=LOOKUP(B1,{0,31,61,91,121},{"0-30","31-60","61-90","91-120",">120"})

5. Re: Formula for Aging in days

thank you very much, it was a smart way...

6. Re: Formula for Aging in days

Welcome to the board.

7. Re: Formula for Aging in days

Hi, how to include negative value from reference cell while applying the above formula.

Regards

8. Re: Formula for Aging in days

Add the negatives to the left end of each array..
The key is for the first array to be sorted ascending left to right.

=LOOKUP(B1,{-30,0,31,61,91,121},{"-30--1","0-30","31-60","61-90","91-120",">120"})

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
•