Hello:
I have attached excel file that contains a column transaction type (Payment/Invoice), Date and Amount. I would like to know how to calculate the ageing report based on a FIFO basis of payments received as well as the invoices. There are two excel worksheets in this file. Can any one help out?
Thank You.
Manoj Kumar
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)
Richard Buttrey
RIP - d. 06/10/2022
If any of the responses have helped then please consider rating them by clicking the small star iconbelow the post.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks