Forum Discussion
Advice needed: Comparing Committed vs Actual Donations in Excel
I would like to compare committed donations versus actual donations received for an NGO. Scenario Every month, quarter, half-year, and year, different groups of people commit to donati...
FIrst of all, you must set the information as follow:
Donor
Committed amount
Date on which he committed to donate the sum
Effective amount
Donation data
The monthly, quarterly, half-yearly, and yearly you can retrieve from date, and/or group in a pivot table,
bye.