Hi,
I am maintaining our receivables in an excel files and maintaining a column on the Payment-1,Payment-2 ..dates of payments (mm/dd/yy) Separately.
I use Pivot Table for reporting purposes. I am looking for a way to take the reports on Payment received MONTHLY. I tried many possibilities but I don't know how get the particular month-wise payment-1&2 received report. Can someone help.
Regards,
Mohanraj.D