Note: In order to use the spreadsheet examples, you need to download Business Functions
|MatchPmts (TheDate, PmtDates, Pmts)|
|Make Payments if the payment dates match the date in question|
|Makes one or a number of payments provided the date matches a payment date|
|Auto Array Function|
This function makes a payment if the date is equal to a payment date.
Whats good or unique about it
MkPmts can in theory do what this function does with a bit of persuasion, but if you want to make absolutely sure a payment is made ONLY IF the day of the PmtDate matches TheDate, and you want to have nothing to do with specifying a timeperiod, this function is the one.
TemplatesThis function features in the following downloadable spreadsheet template(s):