Re: Excel Aged Receivable formula to calculate 0-30 days, 61-60 days,.

H

Haldun Alay

assume that invoice date is in cell A1, following formula calculate aging.

=IF(TODAY()-A1<=30,"0-30 days",IF(TODAY()-A1<=60,"31-60 days",IF(TODAY()-A1<=90,"61-90 days","over 90 days")))

king regards.

--
Haldun Alay


"Aged Receivables" <Aged (e-mail address removed)>, iletide şunu yazdı I need to create a spreadsheet for Aged receivables. I need to know how to
set up a formula to calculate if invoice is 0-30 days old, 31-60 days old,
61-90 days old etc.
If anyone can help me I would appreciate it.

Thanks

Susan
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Conditional Accounts receivable Aging Analysis 0
summing up values with in date intervals 2
How do I calculate percentages in a pivot table? 1
Account Receivable Aging 1
convert date of birth to mos. old now, 30 and 60 days 1
Embedded If Limitation 10
Accounts Receivable Aging Report 1
Aging Receivables Not working 16

Top