Hello,
I need some help with creating calculation fields incorporating dates. My end users enter a date (implementation date), a dollar amount and a number of month entry (how many months they want to divide their savings into equal amounts). The list would look like this:
Implementation Date: 1/1/2026
Savings: $12,000
Number of months: 12
A simplistic entry for the purpose of posting here.
An existing fomula column would take $12,000/12 - returning $1000 per month calculation.
I also have a calculated column that tells me Implementaion Month Number (ie Jan = Month 1) and Imp Year.
I would like to create additional calculated columns that would tell me savings for each month name - Example:
Jan 13 - $1000
Feb 13 - $1000
Mar 13 - $1000 etc.
My max allowable Number of Months for the end user is 36 Months. So my monthly savings will run out a few years, so I will need to create 3 Years of Monthly columns, each with a formula.
If I was dealing with only 12 Months - Jan to Dec same year, I would not have a problem. I am perplexed trying to incorporate the month and the year.
Thanks