arlene_fool
Board Regular
- Joined
- Feb 17, 2007
- Messages
- 55
I am working on a spreadsheet to track my companys accounts receivables, i want to it to age based on todays date, whereas before i just aged it all to the end of the month. i have created this formula
=LOOKUP(($D$5-F26),{1,30,61,91,0},{"Current","30-60","61-90","90+",""})
where D5 is =today() and F26 is the invoice date.
most of it works, except any invoices over 92days are blank, when they should say "90+"
=LOOKUP(($D$5-F26),{1,30,61,91,0},{"Current","30-60","61-90","90+",""})
where D5 is =today() and F26 is the invoice date.
most of it works, except any invoices over 92days are blank, when they should say "90+"