Aging Report

01/13/21
Accepted

Hi there,

I am developing an invoice aging report and created an Aging column using =TODAY() - [Column Name]@row. I would now like to display the Payment Balance amounts in their appropriate Aging category (<30 Days, 31-60 Days, 61-90 Days, 91-120 Days, 121+ Days) according to the Aging column value. I’ve figured it out for the <30 Day and 121+ Day columns but the three “range” columns are giving me trouble. My last attempt below gave me an #INCORRECT ARGUMENT SET error. 

=IF(AND([email protected], >=31, <=60, [Payment Balance - FINANCE]@row))


Any suggestions?

Thanks,

Ali

Best Answer

Answers

Sign In or Register to comment.