Formula Help
I need to calculate a couple of things for the cost of a resource The first year costs, but each "start date" is different. and the year end needs to be 12-31-[whatever year the start date year is...
Forum Discussion
So for the end date, you can do a simple adjustMonth like:
End Date = AdjustMonth([Start Date],[Term])
For the first year Cost - do you have to account for a partial month? If everyone will have a start date of the first of the month you can do something like:
12 - Month([Start Date]) + 1
IE 12 - 4 (for April) + 1 = 9 Months to pay for the first year.
Then multiply that by the monthly rate. If you have partial months, you'll need to evaluate the number of work days in that month and divide that into your monthly rate to get a partial rate for that specific month in question.
------------------------------
Chayce Duncan
------------------------------
