Receivable Ageing Report

Hi,

B1:

Formula:

=SUMIFS($C$8:$C$23,$B$8:$B$23,">="&TODAY()-30)

B2:

Formula:

=SUMIFS($C$8:$C$23,$B$8:$B$23,">="&TODAY()-60)-B1

B3:

Formula:

=SUMIFS($C$8:$C$23,$B$8:$B$23,">="&TODAY()-90)-SUM(B1:B2)

B4:

Formula:

=SUMIFS($C$8:$C$23,$B$8:$B$23,"<"&TODAY()-90)