Skip to content

Instantly share code, notes, and snippets.

Last active June 15, 2023 09:41
  • Star 0 You must be signed in to star a gist
  • Fork 1 You must be signed in to fork a gist
Star You must be signed in to star a gist
Save ncalm/df3ff859473bea58c3160aac693eddf7 to your computer and use it in GitHub Desktop.
Creates a series of dates for a payment schedule.
- start_date - the starting date of the payment term (typically the date the first payment is due)
- term_years - the number of years over which the payment must be made
- period_months - the number of months between each payment
- endpoint_offset - OPTIONAL - the number of periods to include before the first payment date and after the last payment date
PMT.DATES =LAMBDA(start_date,term_years,period_months,[endpoint_offset],
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment