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))