Number of Month Payback ROI
I have created a form and the pictures below is what is relevant to my question. We have projects with a fiscal year start date and end date, we also want to know the payback date. I did not chose the "date" function on the column as we are only interested in the fiscal year, but maybe there is a work around.
What I am trying to do is automatically calculate the "Investment will be paid back by" column. What I have so far is a calculation that determines how many months and then it is added to the "Fiscal Year Start Date Column" as you can see it produces "6-2020/21", ideally I would like it to show June-2020/21. Something along those lines.
Help Article Resources
Check out the Formula Handbook template!